Table : Change Column for row and row for column | Excel forum

Hi Emmanuelle,

Thank you for your question. Give this a try and see if it is more successful.

First review your table that you would like to transpose and note how many rows and columns it contains.

Highlight where you would like the transposed table to appear. For example if your source data is four columns wide by two rows deep you will need to highlight your destination area as two columns wide by four rows deep.

With the cells highlighted click the function wizard button (fx) at the start of the formula bar. This brings up the function wizard dialog box.

In the wizard's search box type Transpose and click Go. From the list of functions that appear double click Transpose.

We are almost there.

We need to tell the transpose function to use your source data. To do this click on the button beside the Array entry box to collapse (has a small red arrow) your dialog box out of the way and then highlight the source data you would like to transpose. Expand the dialog box back up by clicking on the same button..

Finally to commit your formula press Ctrl + Shift + Enter at the same time (instead of just Enter). This will enable the function to work with the whole array of your data and insert {} brackets.

Your destination cells will contain a transposed version of your source data. Formatting is not transposed so you will need to reapply special formats as required.

I hope this helps - let us know how you get on.

Kind regards,
Andrew