Merging data sets from two tables with origin reference In a Google Sheet, I have multiple tables containing a list of dates. I want to create a single (sorted) list containing all the dates and the table they came from.  Table foo: 1.1.19 3.1.19  Table bar: 2.1.19 4.1.19  Result: 1.1.19 foo 2.1.19 bar 3.1.19 foo 4.1.19 bar   Is this somehow possible with regular formulas or do I need to switch to custom functions here?
Combine two columns into a list of all possible combinations of entries I have two columns such as:  a   1  b   2  c    and I need to combine them like:  a   1 a   2 b   1 b   2 c   1 c   2   Is it possible with a formula?
Can a finite group act freely (as homeomorphisms) on $\mathbb R^n$ I am asking if whether or not a finite group acts freely (as homeomorphisms) on $\mathbb R^n$.  To answer in the negative, it suffices to show: for any homeomorphism $f$ such that $f^d=\text{id}_{\mathbb R^n}$, then $f$ has a fixed point.  I am looking for a complete self-contained answer. Why didn't the Alliance send for Yoda instead of Obi-Wan? I am attempting to search jobs by tag on StackOverflow Careers. On SO, this is done using square brackets, but that is simply doing a keyword search, and I still get results that don't have the tag I am looking for.  For example, when I search for the keyword "android", I get this:        which is the same as when I search for the keyword "[android]":        Is there a format I can use to search jobs by tag? If not, I believe this would be a nice feature (seems intuitive for the Stack Exchange invite-only job site). I have a quick question about buttons that toggle between two states. (Think Play/Pause, or Shuffle/Regular Play.) As the title says, should the toggle show it's current state or the state to which it will transition?  I think people are used to the Play/Pause convention. But the Shuffle/Regular play might be more confusing if you show the transition state instead of current. For example, the built-in music player on the Xbox 360 does it this way: when it's in shuffle mode, it shows the icon for direct play and vice versa and it always confuses me (am I in shuffle mode or straight play).  I see it this way: Play/Pause is more like action as in begin playing or pause playing. Yes behind the scenes it is a state transition but to the user, there is an action. Whereas Shuffle/Straight Play is an option and it's best to show the current state (and possibly have only one icon and change button to show that the option is enabled/disabled). Thoughts? How to set identity_insert to on in SQL Server javax.persistence.PersistenceException : [PersistenceUnit: vodPersistenceUnit] class or package not found Why does energy have to be emitted in quanta? I was reading some popular science book and there was this sentence. It says that energy has to be emitted in discrete portions called quanta. Otherwise the whole energy in the universe would be converted into  high frequency waves.  I'm not a physicist, so this conclusion seems to me like a huge leap.  First, we assume that energy is emitted in a continuous way (not in quanta).  And how do we get to the statement "the whole energy in the universe would be converted into  high frequency waves"? I flew a long range flight carrying my laptop, a quite heavy one, inside a neoprene briefcase in the passenger cabin. The recommendation by the aircrew was to place it in the overhead compartment or under the seat in front of me. However, during take-off and landing, the vibrations on the plane are quite strong and, as a result, it received minor damage.   Placing them in the overhead compartment might be equivalent to placing it on the floor under the seat, with the added issue of additional luggage in the compartment shifting.  I considered the alternative of holding the laptop by the handle while sitting, so it won't be any contact with the aircraft's floor. This is impracticable during cruise, but I thought it could be better during the take-off and landing segments. Another option I considered is to wrap it with completely with bubble wrap before boarding the plane.   Which is the safest way to transport a laptop during flight? Are Lorentz transformations linear transformations? My textbook says that Lorentz transformations are linear transformations and present them as matrices. Lorentz transformations relate different coordinate systems with each other. It seems that coordinate systems are linear spaces, but coordinates are just labels for spacetime points, with no other structures attached. So what is the linearity all about? Is there a way to "auto login" in PuTTY with a password? Is there a way to configure a password for a stored session in ?  I know there is the capability to specify an "auto-login username" (under Connection/Data), but is there a way to do the same with the password? I'm on 10.9, and I had been using internet sharing successfully again for the first time since Lion. Today though, it just decided to stop working again.  Network layout:  Modem -ethernet-&gt; Router -ethernet-&gt; Mac Pro -ethernet-&gt; MacBook Pro Retina   The internet works fine on the Mac Pro, but it is no longer forwarding the proper DHCP settings to the MacBook.  Previously, the MacBook would get the IP address of 192.168.2.12, and was able to surf the web fine. (Though it wasn't able to connect to any AirPlay/AirPrint devices while on the ethernet interface)  Sometime today, a setting got messed up, and I'm not sure how to fix it or what setting it is.  The MacBook now has a "Self-assigned" IP of 169.254.121.24, even though it is set to use DHCP. The ethernet port on the Mac Pro that the MacBook Pro is connected to is showing a "Self-assigned" IP of 169.254.36.53, even though it is set up to use DHCP as well.  The internet sharing options appear to be correct: share connection from Ethernet 1 to Ethernet 2.  But alas, for no apparent reason, I'm not getting internet access. Word for "someone who talks too much" I'm trying to remember a film I saw years ago (1980's?).  The only part I clearly remember is a man and girl being bricked up alive (in a tower?) and escaping by turning his (magically large) coat or cloak into a rudimentary hang glider.  The film had a medieval sword/sorcery setting. How to concatenate text from multiple rows into a single text string in SQL server? How to batch import Wavefront OBJ files? Is it possible to batch import Wavefront .obj to blender? I'm working on 2.69. If I select multiple .obj files, only one gets imported. Also if I hit A on file selection window to select all files (.obj and .mtl) I get an error, nothing gets imported. I have to import several hundreds of .obj into the blender file, is this possible? $SU(3)$ irreducible representations with tensor method Is it possible to recover original content from an edited image file? OK possibly a random question here, but one that is relevant to the site and regarding a hot topic nowadays: privacy.  If I load an image file (in my case a PNG photocopy of a document which contains some personal details) into Gimp, and I 'fill' with black (i.e. as if to redact) the areas of the image that contain sensitive information, and I then overwrite the original file, is there any way that the original untouched image can be recovered or gleamed? Such as low level bit analysis or...?  If so what tools and techniques are behind that, and how can I mitigate this? Is it a simple case of not overwriting the original but simply creating a new file with the changes? How do neutrinos pass through the sun so quickly? If it takes thousands of years for light to escape our sun then how can neutrinos generated in the very center of the sun reach earth in just 8 minutes? Why is their speed so great that they can easily escape the pull of the sun at near light speed?     Solar neutrinos originate from the nuclear fusion powering the Sun and other stars. The details of the operation of the Sun are explained by the Standard Solar Model. In short: when four protons fuse to become one helium nucleus, two of them have to convert into neutrons, and each such conversion releases one electron neutrino.   The Sun sends enormous numbers of neutrinos in all directions. Each second, about 65 billion ($6.5\times 10^{10}$) solar neutrinos pass through every square centimeter on the part of the Earth that faces the Sun.[8] Since neutrinos are insignificantly absorbed by the mass of the Earth, the surface area on the side of the Earth opposite the Sun receives about the same number of neutrinos as the side facing the Sun.   - I just read a description of CVE-2020-1971, which indicates that a patch was released today for openSSL, the patched version is 1.1.1i -- my version of Ubuntu 20.04.1 LTS is running openSSL version 1.1.1f.  From last March. Software Updater says that my system is up to date.  I am hoping that this openSSL update is released by Canonical by tomorrow... can anyone confirm they are working on this? Where can I ask about Software Licenses/Licensing? Is it appropriate to ask questions about software licenses/licensing on ? Or is the appropriate place  ? Or is there no appropriate site currently and we should suggest such a site on ?