Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transposing Array | Excel Worksheet Functions | |||
need help with transposing | Excel Discussion (Misc queries) | |||
Transposing | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
transposing an array converts dates into numbers | Excel Worksheet Functions |