Wed 21 Feb 2007, 10:04Delegate Gurmit said...
Gurmit has attended:
Excel Advanced course
Transposing
How can I transpose a Spreasheetcolumn headers to appear in the rows instead ?
ie- I have created a spreadsheet with products on the headers and have just realised that there are so many products and I now need to bring these products down into the Rows.
Wed 21 Feb 2007, 10:19Trainer Garry said...
RE: Transposing
The columns and rows are all wrong, you have to swap all the Excel
books and sheets. All you have to do is:
Highlight the header rows then copy then go to edit on the menu bar
paste Special the select transpose
