Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting a large vertical mailing list into a horizontal format
I've copied a vertical list of over 1000 customers ID #'s, names and
addresses and pasted the info into column A in Excel. This info will be transferred to a letter for each customer. For this to work effeciently the customer info needs to be sorted horizontally in specific columns. Example: A B C D 98-2004 John Doe 5555 Road Lane Town, State 77777 I know how to do these individually, but what is the method to do this more quickly? Thank you so much for your help! |
#2
|
|||
|
|||
No harm giving this a try ..
Assume the mailing list is all in groups of 4 lines (w/o any blank lines in between groups) in Sheet1, from A1 down (sample below) 98-2004 John Doe 5555 Road Town, State 11111 98-2005 Peter Taylor 1111 Lane Town, State 22222 100-2004 Mary Dees 8888 Road Lane Town, State 88888 etc In Sheet2 ----------- Put in A1:=OFFSET(Sheet1!$A$1,ROW()*4-4+COLUMN()-1,) Copy A1 across to D1, fill down until zeros appear signalling exhaustion of data from Sheet1 This'll return the list from Sheet1, placing each line per group of 4 lines nicely into cols A to D as required Freeze the values in cols A to D with a copy paste special values either in-place or elsewhere -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Kevin VanHalen" <Kevin wrote in message ... I've copied a vertical list of over 1000 customers ID #'s, names and addresses and pasted the info into column A in Excel. This info will be transferred to a letter for each customer. For this to work effeciently the customer info needs to be sorted horizontally in specific columns. Example: A B C D 98-2004 John Doe 5555 Road Lane Town, State 77777 I know how to do these individually, but what is the method to do this more quickly? Thank you so much for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel column headers to a vertical list | Excel Discussion (Misc queries) | |||
How do I search a mailing list spreadsheet to remove entries alre. | Excel Discussion (Misc queries) | |||
which is best for mailing list management, Outlook or Excel? | New Users to Excel | |||
How can I combine 3 separate mailing list? | New Users to Excel | |||
how do I convert a list in Excel to mailing labels | Setting up and Configuration of Excel |