Changing or combining serveral rows into one column

[Pacific1]

Hello, this is a bit more complicated than I thought it would be.


I have the following date in table1. I need the query result to look like it does in the result table.
Any Suggestions would help

Thanks

TABLE 1			Result
ColumnA	ColumnB		ResultA	ResultB
AA	5		AA	5,67,8
AA	67		BB	9
AA	8		CC	75,86
BB	9		DD	32
CC	75		EE	25,23,19
CC	86
DD	32
EE	25
EE	23
EE	19

[orange]

Pacific1,

It seems (to me) you are in a spreadsheet mode.
It can be done in Access, see this function from Allen Browne.
Good luck.