Tom.Jones
Well-known Member
- Joined
- Sep 20, 2011
- Messages
- 506
- Office Version
- 365
- 2016
- Platform
- Windows
- Mobile
Hi,
Please help me in the next problem.
In A1: ZL1 are texts. How could I do that, starting with A2, to transpose the data from the odd cells (A1, C1, E1, ..... ZK1) into A2: A345,
and the data from the even cells (B1, D1, F1, ..... ZL1), from the range A1: ZL1 to be transposed into B2: B345.
Thank you.
Please help me in the next problem.
In A1: ZL1 are texts. How could I do that, starting with A2, to transpose the data from the odd cells (A1, C1, E1, ..... ZK1) into A2: A345,
and the data from the even cells (B1, D1, F1, ..... ZL1), from the range A1: ZL1 to be transposed into B2: B345.
Thank you.