How to convert horizontal data to vertical in excel?
Answers
Answered by
0
1. Select the row data and press Ctrl + C to copy it. See screenshot:

2. Click at a cell you want to output the result, and right click to open context menu, click Paste Special > Transpose in Excel 2010 and 2013. See screenshot:

In Excel 2007, after selecting the Paste Special from the context menu, it will open the Paste Special dialog. In the dialog, please check All option and Transpose option, and click OKbutton.

Now the row data has been transposed to a column of data.

Please mark as brainliest...

2. Click at a cell you want to output the result, and right click to open context menu, click Paste Special > Transpose in Excel 2010 and 2013. See screenshot:

In Excel 2007, after selecting the Paste Special from the context menu, it will open the Paste Special dialog. In the dialog, please check All option and Transpose option, and click OKbutton.

Now the row data has been transposed to a column of data.

Please mark as brainliest...
Similar questions