Do you mean that you want to swap the data in your sheet so the rows become
columns and the columns become rows?
If so, you need to use "Paste Special, Transpose". Here's how to do it:
1. Select the range of the data.
2. Choose Copy
3. Select 1 cell in another area (or even better, on another sheet) to be
the starting point for pasting into
4. Choose Paste Special
(in 2007, Home Ribbon, bottom half of paste button;
in any older version, Edit menu)
5. Click Checkbox for Transpose.
Do you mean that you want to swap the data in your sheet so the rows become
columns and the columns become rows?
If so, you need to use "Paste Special, Transpose". Here's how to do it:
1. Select the range of the data.
2. Choose Copy
3. Select 1 cell in another area (or even better, on another sheet) to be
the starting point for pasting into
4. Choose Paste Special
(in 2007, Home Ribbon, bottom half of paste button;
in any older version, Edit menu)
5. Click Checkbox for Transpose.
Highlight all the data you want to rotate and choose Copy.
Find a new place where you can paste the data, for example go to Sheet2, and
right-click in cell A1. Now go up to the Edit menu and choose the Paste
Special option. Look for the option called 'Transpose' and select it, then
click OK. Done.
Highlight all the data you want to rotate and choose Copy.
Find a new place where you can paste the data, for example go to Sheet2, and
right-click in cell A1. Now go up to the Edit menu and choose the Paste
Special option. Look for the option called 'Transpose' and select it, then
click OK. Done.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
