Getting Rid of Blank Values in a Grouped Export

[mcbrady]

I'm trying to condense a small data set into all possible unique combinations of 5 different fields. However, I get a table that displays as a sorted hierarchy, with blanks where any repeated values would be. For example I get:

5/12/08 3 4 5 6

6 7 8 (This example should line up down the right side)

8 1

9

When what I need is:

5/12/08 3 4 5 6

5/12/08 3 6 7 8

5/12/08 3 6 8 1

5/12/08 3 6 8 9

Can somebody please shed some light on how I would get a full set of unique values in a data table created by exporting a set of data which is sorted/grouped by each of the 5 fields?

Thanks in advance

Edited August 21, 2008 by Guest