How can I move multiple columns data into a single column so that:

Name Age Location
Mike 25 Essex
Jack 32 Surrey
Bob 36 Newcastle

appear in a single column with data appended column-wise as

Mike
Jack
Bob
25
32
36
Essex
Surrey
Newcastle

Any help would be much appreciated. I'm a novice at VBA, so if anybody could do the code, it would be great!

I will be sorry I ask this but why in the world would you need your data presented in that manner? Is this going to be in a report?

the reason is that i want the data in the above format in a text file which will then be used as part of a program in AutoCAD.

So, if I can get this done in Access, I could export it into a text file and use it from there on.

I've seen some code for doing it the other way round, which you are right is more logical........but at present, this is what I need. Any clues of how to do it in Access or even in a text file?

I just got it wrong........sorry for that.

I need to append the data row-wise and insert in into one column that is:

Mike
25
Essex
Jack
32
Surrey
Bob
36
Newcastle

Any idea, what the SQL code would be? Thanks