I'm using Google Spreadsheet and would like to convert a table into a single column of values so I can paste them into another program.
Original Data:
x y z
a b c
Desired Outcome:
x
y
z
a
b
c
Is there a formula I can use? I don't care what order the resulting list entries are in.
Best Answer
It is not completely clear how your data is structured. In case cell A1 = x y z and cell A2 = a b c, and values are separated with " " , try:
In case A1:C1 = x y z and A2:C2 = a b c, try:
And in case both don't work, please consider sharing an example spreadsheet so we can have a better look.