training ms excel advanced - Data table, rotate

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

Resolved · Low Priority · Version Standard

Data table, rotate

Adam has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Adam [2 posts] (2007 Feb 9 Fri, 17:05) Reply

I have a table of data in excel that i effectively need to change to landscape. I need the column headings to instead be down the left handside and the left handside headings accress the top. Is there a quick way of doing this without re entering the data?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: data table, rotate

by - trainer Amanda platinum contributer [947 posts] (2007 Feb 12 Mon, 15:02) Reply

Hi Adam

Thanks for your question.

Luckily you don't need to re-enter all your data!

If you select and copy the data you wish to redisplay, then go to a new sheet and select the cell where you want the data to start from.

Go to Edit - Paste Special. Click the Transpose option down the bottom of the dialogue box and click OK.

This should turn columns into rows and rows into columns.

Amanda

· A Beginners Guide To Formulas In Excel
· How to Create Better Excel Spreadsheets: Part Four
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· How to Create Better Excel Spreadsheets: Part One
· Benefits of learning about Excel charts

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips