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

A

Ah 3

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to convert multiple columns of data into one single column? 3
modified pivot table using a macro 2
Conditional Format Formula for finding duplicates in a row 1
inserting data in a column based on data in another 0
Pivot Tables to summarise a column in one row? 1
How to write a macro to selectively output certain data to a different table based on 3
Crosstab Query - Multiple Value Responses 2
retrieving values from a certain column 2

Top