I am trying to find a way of tranposing large datasets (the structure is shown below) in a certain way and wondering how to implement it in Excel using a formula as to avoid time-consuming and error prone copy-paste transpose!
I want to do the transformation of the data on sheet A
on a separate sheet (B
). I essentially have triplicate measurements multiple features of different groups. The number of groups can vary but the measurements will always be in triplicate.
Thanks for any help you can give