When you have
an Excel worksheet with data in columns that you want to rearrange in rows - or
vice versa - Excel’s Transpose feature can help you do that.
Here’s what you do:
Select the
range of data you want to rearrange, including any row or column labels, and
copy it.
Next, pick a spot in the worksheet that has enough room to paste your data.
Right-click the
first cell where you want to paste the data, and select Transpose.
The data you
copied will overwrite any data that’s already there.
No comments:
Post a Comment