ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 293
- Office Version
- 365
- Platform
- Windows
Gurus,
I am trying to transpose a range of rows by 3 columns into a single row by 3 columns. Please see below;
table 1 is the original format while table 2 is the expected result.
Is there any excel button that can do the transposition? Excel vba can help too.
Thank you very much,
I am trying to transpose a range of rows by 3 columns into a single row by 3 columns. Please see below;
table 1 is the original format while table 2 is the expected result.
Is there any excel button that can do the transposition? Excel vba can help too.
Thank you very much,