Hi All
I'm trying to transfere details that i have in a list and place into a table, in either Excel or Word. I am struggling a bit at the moment and was hoping someone may be able to help me
In the excel document that i have it contains peoples First Name, Surname and Address:
Column A = First Name
Column B = Surname
Column C = First Line Of Address and so on
The rows go down to Row 122.
What i am aiming to do it to take Columns A and B and put the name into a table (4 columns wide) in alphabetical order reading from left to right.
Each Column on the new table must contain the First Name and Surname
For Example:
Mrs Anderson Mr Andrews Mr Brown Mrs Carpenter
Mrs Cosgrove Mr Davies etc etc
etc
I tried doing it by copy and pasting columns A and B into a Word Document, merging the cells and then Format > Columns and selected 4 Columns.
The table that i pasted split into 4 colums but i couldn't get them into Alphabetical order from left to right and i could get the equal amount of Rows in each column.
I would be ever so grateful if someone could please shed some light on how i can achieve this.
Many thanks in Advance
Mark
Bookmarks