Quote:
Originally Posted by Kevin@Radstock
Hi srm6
You want to invert your data!
Assuming data is on Sheet2 A1:C12 including column headers.
On sheet1 in A2 copy across to C2 & down to C12:
=INDEX(Sheet2!$A$2:$C$12,ROWS(2:$12),COLUMNS($A:A) )
Kevin
|
Thanks Kevin. This formula worked perfectly for the information I provided to you however, when I entered it into my massive spreadsheet (19804 rows) and tweaked a few things here and there to match the columns it didn't work properly. Can you explain the steps in the formula so I can see where I tweaked it incorrectly?
The formula is in my "Raw Data" sheet column A.
It is pulling information from my "Column and Sheet Names" sheet columns G, H, I.
This is the formula after I tweaked it.
=INDEX('Column and Sheet Names'!$I$2:$I$19804,MATCH(B2&C2,'Column and Sheet Names'!$G$2:$G$19804&'Column and Sheet Names'!$H$2:$H$19804,0))