View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jreinier jreinier is offline
external usenet poster
 
Posts: 1
Default Excel data formatting


I would like to swap the data in an Excel spreadsheet by changing the
columns to rows, and the rows to columns, For example:

This: 1 2 3 Would become this: 1 4 7
4 5 6 2
5 8
7 8 9 3
6 9

Is this possible, and if so how can I do it? I have a large amount of
data and performing this by hand would take an extreme amount of time.

Any assistance you can provide would be appreciated.




--
jreinier