ExcelBanter - Convert columns to rows

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

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

- - Convert columns to rows (https://www.excelbanter.com/excel-worksheet-functions/113350-convert-columns-rows.html)

Convert columns to rows

Hi dear

I have some products in column A and their different prices in column B. I
want to get the prices of rch items in Column A as row 1, row 2 .. etc. as
there are many prices for same items.

Thank you in advance for your valuable solution.

Carim

Convert columns to rows

Hi,

Edit Copy
Edit PasteSpecial Transpose

HTH
Cheers
Carim

All times are GMT +1. The time now is 09:31 AM.