1

I'm working on a Google Sheets document that has data stacked in columns in an unusual order (see image for reference)

I have what you see on columns A, B and C. But I want what I have on column E. I have 8 pages with hundreds of data elements, all sorted in 3 columns like that and I'm looking for a formula or a custom script that would allow me to arrange the data in the right sequence.

I did research trying to find a solution, but none of the ones I found work well for this situation. The order of the elements is very important.

enter image description here

EDIT: The data is not numbers. It's text. So sorting formulas wouldn't work, because it would sort it alphabetically and it would mess up the order

player0
  • 124,011
  • 12
  • 67
  • 124
Alfie Robles
  • 164
  • 3
  • 16

2 Answers2

2

all you need is:

=FLATTEN(A1:C7)

with open ranges you can do:

=QUERY(FLATTEN(A1:C); "where Col1 is not null"; )

see: https://stackoverflow.com/questions/73767719/

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
1

try:

=SORT(ARRAYFORMULA(FLATTEN(A1:A,B1:B,C1:C)),1,1)

enter image description here

rockinfreakshow
  • 15,077
  • 3
  • 12
  • 19
  • Thanks! I just added an edit to the question. The data is actually text, not numbers. So this formula sorts it alphabetically and it messes up the order. – Alfie Robles Dec 06 '22 at 19:37