Please advise how to exchange data from row to column & column to row.
Thanks a lot!
Please advise how to exchange data from row to column & column to row.
Thanks a lot!
Try this,Originally Posted by Crystal Lei
enter values in range A1 down to what ever....
enter this in C1 and then drag formula across
=INDIRECT("Sheet1!$A$"&COLUMN()-2)
Look up the TRANSPOSE function in Excel's Help menu.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks