Change ROWS into COLUMNS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please, HELP!!!
Is there any way in which I can change a huge amount of data that is in row
format to columns???????
 
If the number of rows is less than the maximum number of columns (256 in
Excel up through 2003; 18,000 and change in Excel 2007) you can copy the
data, then do a Paste Special from the Edit menu and choose the Transpose
option.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Back
Top