ExcelBanter - Columns to rows

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Columns to rows (https://www.excelbanter.com/excel-worksheet-functions/117425-columns-rows.html)

Azrael

Columns to rows

I have a column of numbers A1 though A15 that I need to display in a row
(i.e. A1 though O1), what is my best or easiest way to do this?

--
Azrael

Roger Govier

Columns to rows

Hi

Copy the range, place cursor in B1Paste SpecialTranspose
Delete cell A1
--
Regards

Roger Govier

"Azrael" wrote in message
...

I have a column of numbers A1 though A15 that I need to display in a
row
(i.e. A1 though O1), what is my best or easiest way to do this?

--
Azrael

All times are GMT +1. The time now is 09:35 PM.