Creating Lists with multiple rows

  • Thread starter Thread starter billydog
  • Start date Start date
B

billydog

I have a list with three rows each. Does anyone know how
I can sort these entries with all three rows included? I
have tried to associate them, but cannot find a way. Any
help would be greatly appreciated.

Thank you.
 
Use a helper column and use it to do your sorting..........ie, if you have
Name in row 1, address in row 2 and phone in row 3.........the helper column
should read Name001 in row 1, Name002 in row 2, and Name003 in row
3.........then when you sort on that helper column, the address and phone
will stay with each Name...........

But, unless you really "need" that format, you'ld probably be lots better
off in the long run by putting all the info in cells across one row for each
name...........

Vaya con Dios,
Chuck, CABGx3
 
Thanks Chuck, butI have over 3000 rows that were imported
from a table, which include over 1000 addresses. Is
there anyway to format each address(row of 3) to merge?

-----Original Message-----
Use a helper column and use it to do your
Click to expand...
sorting..........ie, if you have
 
If you're wanting to stick with the 3-row format, then probably just build a
helper column of "001,002,003, 001,002,003, etc etc" and then work out some
combination of Concatenation and IF statements and/or other TEXT functions
such as MID or LEFT etc that could identify the FIRST line of each
combination and put the two together as NAME001, NAME002, NAME003, etc but
it would have to be specifically tailored to the type of data you
have........or maybe someone could write you a Macro that would just go
through and do it all at once, but thats beyond my skills.

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top