advanced excel training - Transposing

The UK's most regular instructor-led training courses.
Training information: advanced excel training · Excel advanced · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Transposing

Gurmit has attended:
Excel Advanced course

by - delegate Gurmit [3 posts] (2007 Feb 21 Wed, 10:04) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Transposing

by - trainer Garry gold contributer [188 posts] (2007 Feb 21 Wed, 10:19) Reply

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

· Microsoft Excel's Best Kept Secret
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Microsoft Excel Training: Essential for Today's Employees
· Tap the Power of Recorded Macros with MS Excel Courses
· Compare Different MS Excel Training Methods