Move not remove dupes (1 Viewer)

[mohobrien]

I have a table that I'm trying to sort into different new tables or at least new fields. The original is like this:
A
B
B
C
C
C
D
E
E
and I'm trying to output this:
A
B B
C C C
D
E E

Is there a way without using vba to iterate through the table?

 

[Jon K]

With queries, the closest you can get is something like the following:

Fld	Dup1	Dup2	Dup3
A	A		
B	B	B	
C	C	C	C
D	D		
E	E	E

The contents of the first column will be repeated - a limitation of crosstab query.
.