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

  • Thread starter Thread starter Ah 3
  • Start date Start date
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!
 
You must log in or register to reply here.

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? 5
Transpose multiple columns, functions 6
copy data for match word from one file to another file 1
Pivot Tables to summarise a column in one row? 1
Excel Converting rows into each individual reports 0
Formula for counting more than one criteria 1
How to find best and worst grade? 5
Crosstab Query - Multiple Value Responses 2

Back
Top