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!



Posted by Scott H on September 14, 0100 4:38 PM

Try using the autofilter function on the grid. Go to Data>Filter>Autofilter. What you see is a drop down arrow in each cell across the top of your grid. Click on the arrow in the group name column and select the group you need. The result is the other rows are hidden entirely from view.

You can even copy and paste multiple rows (without the hidden ones!)