Katchap902
New Member
- Joined
- Feb 2, 2022
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
I have some complex data in a table I want to transpose in excel. In the table below I want take the 'element' column and transpose it so each individual element is listed as a column number per sample tag. The first image is how the data is currently presented and the second image is how I want it displayed . I have 100000's of records to do this for.....
I have some complex data in a table I want to transpose in excel. In the table below I want take the 'element' column and transpose it so each individual element is listed as a column number per sample tag. The first image is how the data is currently presented and the second image is how I want it displayed . I have 100000's of records to do this for.....