ExcelBanter - Excel 2007 Transposing Multiple Columns

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel 2007 Transposing Multiple Columns (https://www.excelbanter.com/excel-programming/415083-excel-2007-transposing-multiple-columns.html)

Pittman

Excel 2007 Transposing Multiple Columns

How do I transpose the following columns to rows example, to get the prefered
results:

Transpose Columns To Row

A1 B1 D1
Apples Oranges Apple Oranges Grapes Pears Bananas
Plumbs
Grapes Pears
Bananas Plumbs

--
Marcus

All times are GMT +1. The time now is 05:19 PM.