![]() |
Transposing Array
Hi,
I have approx 6 years worth of data I would like to transpose. Currently data is listed as: A1: Jan-07 B1: Feb-07 C1: Mar-07 A2: 25-Dec-06 B2: 20-Jan-07 C2: 17-Feb-07 A3: 26-Dec-06 B3: 21-Jan-07 C3: 18-Feb-07 etc Result I'm after is: A1: Jan B1: 25-Dec-06 C1: 26-Dec-06 B2: Feb B2: 20-Jan-07 C2: 21-Jan-07 etc I understand how to transpose one column but am struggling to understand how to copy an array. Any help will be greatly appreciated. |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com