ExcelBanter - how to convert multiple columns of data into one single column?

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

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

- - how to convert multiple columns of data into one single column? (https://www.excelbanter.com/excel-worksheet-functions/6301-how-convert-multiple-columns-data-into-one-single-column.html)

Ah 3

how to convert multiple columns of data into one single column?

as subject, e.g.

from...

A B C D
Mary Peter Paul David
John Nancy Lucy Ken
Alice Annie Danny Jane

to...

A
Mary
John
Alice
Peter
Nancy
Annie
Paul
Lucy
Danny
David
Ken
Jane

Many thanks!

Frank Kabel

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"Ah 3" schrieb im Newsbeitrag
...
as subject, e.g.

from...

A B C D
Mary Peter Paul David
John Nancy Lucy Ken
Alice Annie Danny Jane

to...

A
Mary
John
Alice
Peter
Nancy
Annie
Paul
Lucy
Danny
David
Ken
Jane

Many thanks!

All times are GMT +1. The time now is 07:01 AM.