Creating Lists with multiple rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

billydog - 22 Jul 2004 01:16 GMT

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.

Reply to this Message

CLR - 22 Jul 2004 02:28 GMT

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

> 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.

Reply to this Message

- 22 Jul 2004 04:29 GMT

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 sorting..........ie, if you have
[quoted text clipped - 18 lines]
>
>.

Reply to this Message

CLR - 22 Jul 2004 11:38 GMT

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

> Thanks Chuck, butI have over 3000 rows that were imported
> from a table, which include over 1000 addresses. Is
[quoted text clipped - 33 lines]
> >
> >.

Reply to this Message