ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Copy contents in a row and paste in a column (https://www.excelbanter.com/setting-up-configuration-excel/35462-copy-contents-row-paste-column.html)

CJMFH

Copy contents in a row and paste in a column
 
I'd like to take data in a row and reformat it, putting it into a column.

Can anyone help?

Thanks -:)


Dave Peterson

Select your range
edit|copy
select a cell not in that range
edit|paste special|check transpose



CJMFH wrote:

I'd like to take data in a row and reformat it, putting it into a column.

Can anyone help?

Thanks -:)


--

Dave Peterson


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com