ExcelBanter - Move cells vertically to horizontally

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Move cells vertically to horizontally (https://www.excelbanter.com/excel-discussion-misc-queries/18833-move-cells-vertically-horizontally.html)

Abe

Move cells vertically to horizontally

Hey all, I have a series of items that are in a vertical list in Column A and
I want to move them to run horizontally. Is there anyway to do this?

Thank you!

Abe

Michael

Hi Abe
Have a look at the TRANSPOSE function in Excel Help
It will do the trick.

HTH
Michael

"Abe" wrote:

Hey all, I have a series of items that are in a vertical list in Column A and
I want to move them to run horizontally. Is there anyway to do this?

Thank you!

Abe

All times are GMT +1. The time now is 01:37 PM.