Hi,
I am looking to compile a sorting / ranking table. I have completed the main table but want to transpose the data to an easy to read ranking table. When using the TRANSPOSE function it does not carry the data the way I intend it and using the SORT table options does not extend the data.
The ideal table would look like the yellow table in the second sheet.
Any pointers would be a great help!
Thanks, ChemistryBMS
Bookmarks