Excel data formatting
Select your range right click Copy select your destination cell, right
click paste special Transpose OK out "jreinier" wrote: 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 |
Excel data formatting
Have you tried either the TRANSPOSE function or Copy/Paste Special/
Transpose ? -- David Biddulph "jreinier" wrote in message ... 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 |
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 |
Excel data formatting
Thanks! I really appreciate you responses. Worked great! -- jreinier |
All times are GMT +1. The time now is 02:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com