Converting a grid to a list
Posted by Annette on September 14, 2000 1:57 PM
I have a lovely summary grid of groups and what projects each is involved in.
Now the request is an individual list for each group, listing only their projects.
Example grid:
Project A Project B Project C
G1 X X
G2 X X
G3 X
I can create the list easily enough with an IF..THEN statement, but I'd get blank lines
for the projects that are "skipped" in each row...
Thanks!