ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   want to cut data from vertical cells and paste them horizontally. (https://www.excelbanter.com/excel-discussion-misc-queries/80257-want-cut-data-vertical-cells-paste-them-horizontally.html)

charter_SKR

want to cut data from vertical cells and paste them horizontally.
 
I have data like A B C D E in the columns. I want to cut them and paste
horizontally (in rows).

Don Guillett

want to cut data from vertical cells and paste them horizontally.
 
try looking in help for TRANSPOSE.

--
Don Guillett
SalesAid Software

"charter_SKR" wrote in message
...
I have data like A B C D E in the columns. I want to cut them and paste
horizontally (in rows).




Marvin P. Winterbottom

want to cut data from vertical cells and paste them horizontal
 
instead of paste, use Edit / Paste Special / transpose

"Don Guillett" wrote:

try looking in help for TRANSPOSE.

--
Don Guillett
SalesAid Software

"charter_SKR" wrote in message
...
I have data like A B C D E in the columns. I want to cut them and paste
horizontally (in rows).






All times are GMT +1. The time now is 05:59 AM.

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