Forum Discussion

Mccone's avatar
Mccone
Copper Contributor
Jul 24, 2019

Combine data from multiple rows into a single row

Is there a way to take a single column that is made of 500 rows and have it wrap to 25 columns of 20 rows?

data
excel
Layout

1 Reply

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Jul 24, 2019

    Would you like rows 1-20 of the old data to be in column 1 of the new data, rows 21-40 to be in column 2, rows 41-60 to be in column 3, etc...?

     

    If so, then do the following:

    Assuming all of your data is in the range A1:A500, put this formula in cell C1:

     

    =INDEX($A$1:$A$500,ROW(C1)+(20*(COLUMNS($C$1:C$1)-1)))

     

    and copy all the way to cell AA20.

     

    Hope this helps!

    PReagan

Resources