** Edit **
This question is directly related to the thread - Combining Rows-Opposite of Union.
I tried this approach but for some reason I am getting inconsistent results. When I place debug statements in the Concat function, it appears the query is processing the rows not in the order one would expect.
I expected each of the items in a group would be grouped, but it appears that the debug statement is showing they are processed sequentially which is breaking the function.
the debug shows
Group1 item1
Group1 item2
Group2 item1
Group1 item3
Group2 item2
so the results are jumbled up.
Any ideas?