ExcelBanter - Convert data in excel from A1 to A20 to A1,B1,C1;D1etc

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

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

- - Convert data in excel from A1 to A20 to A1,B1,C1;D1etc (https://www.excelbanter.com/excel-discussion-misc-queries/251092-convert-data-excel-a1-a20-a1-b1-c1%3Bd1etc.html)

Bev[_2_]

Convert data in excel from A1 to A20 to A1,B1,C1;D1etc

--
Bev

Jacob Skaria

Convert data in excel from A1 to A20 to A1,B1,C1;D1etc

--Select A1:A20 and copy the range.
--Select cell B1Right clickPasteSpecial check 'Transpose' and click OK.
--Delete Column A

--
Jacob

"Bev" wrote:

--
Bev

All times are GMT +1. The time now is 03:16 PM.