I have a column of values (up to 144 values). I have several other columns
(up to 12 additional columns) that I want to select those values in the first
column to fill in the rows on the additional columns.

For instance:

Column1
Data1
Data2
Data3
Data4
Data5
Data6
Data7
Data8

Column2
Data1
Data2

Column 3
Data3
Data4

Column4
Data5
Data6

Column5
Data7
Data8



I would think this would involve an INDEX formula, but how would I use it?

Thanks