I need some help in MS Excel. What I need is to be able to switch between the row and column headers. I'm sure there is such a function although I havn't found it ^^. To clarify what I need to do, let me give an example. So let's say I have a grid, (ignore the decimals, just used to get spacing right) ..1 2 3 A B C I need, ..A B C 1 2 3 Can't be more clear then that lol. ^^

I'm copying this directly from the help file in Excel so I'm not sure if the formating will come out right on this page. If it doesn't then look in the help file and type in "swap colums for rows" It will show you this example. Say you have a column of text: Dairy Meat Beverages Produce That you want to change into a row, like so: Dairy Meat Beverages Produce Or maybe you have a row of data that you want to change into a column. Moving the data manually, one item at a time, would be a tedious process. To save time, you can use the Paste Special command to quickly transpose a column of data to a row of data, or vice versa. Move data between rows and columns Copy the data in one or more columns or rows. Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special. In the Paste Special dialog box, select Transpose, and then click OK. You'll find theTranspose check box in the lower-right corner of the dialog box: Starting with your first cell, Excel pastes the data into a row or column. Notes Columns and rows can not overlap. For example, if you select values in Column C, and try to paste them into a row that overlaps Column C, Excel displays an error message. When you go to paste a column or row, the destination area must be outside of the original values. If you copy and paste data from more than one column, Excel places the data from the leftmost column on top. For example, say you copy data from columns A and B of a worksheet, and you paste the data into another worksheet starting at row 1. Excel places the data from column A in row 1, column B in row 2, and so on. If you don't see the Paste Special command, make sure you right-click the first destination cell. You'll also find the command on the Edit menu. If you still don't see the command, make sure you're using Excel 2000 or later.

Additionally, you can transpose a table or range of cells A B C 1 i j k 2 l m n 3 o p q becomes 1 2 3 A i l o B j m p C k n q

Thank you for the reply. Sounded difficult but it was actually very easy once I tried it =).