ExcelBanter - Transfer data in columns to rows

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

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

- - Transfer data in columns to rows (https://www.excelbanter.com/excel-discussion-misc-queries/114955-transfer-data-columns-rows.html)

Transfer data in columns to rows

Is it possible to transfer data in columns to rows?

Dave F

Transfer data in columns to rows

Look at the TRANSPOSE function.
More info he http://www.techonthenet.com/excel/fo.../transpose.php

Dave

--
Brevity is the soul of wit.

"PE" wrote:

Is it possible to transfer data in columns to rows?

evan

Transfer data in columns to rows

Copy Paste Special [x] Transpose

"PE" wrote:

Is it possible to transfer data in columns to rows?

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