S
Scott
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
(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