LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need help with transposing [email protected] Excel Discussion (Misc queries) 2 October 30th 08 02:10 PM
Transposing Nanapat Excel Discussion (Misc queries) 2 April 2nd 08 11:38 PM
meaning of : IF(Switch; Average(array A, array B); array A) DXAT Excel Worksheet Functions 1 October 24th 06 06:11 PM
transposing an array converts dates into numbers Mehmet Excel Worksheet Functions 3 April 21st 06 07:04 AM
TRANSPOSING GARY Excel Discussion (Misc queries) 1 March 17th 06 11:09 AM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"