0

I have data in multiple rows, and I need to combine data in similar columns and separate with a semi colon, to end up with one row with grouped by ID.
I have ID Type

1 A

1 B

1 C

2 D

3 A

3 F

I want results to be

1      A;B;C

2      D

3      A;F

I have limited knowledge of access, but know this should be basic and easy. I appreciate assistance.

braX
  • 11,506
  • 5
  • 20
  • 33
Cookie28
  • 1
  • 2
  • 1
    Possible duplicate of [ConcatRelated function in a query](https://stackoverflow.com/questions/18940038/concatrelated-function-in-a-query) – June7 Jul 07 '18 at 01:23
  • Not really basic and whether it is easy is subjective. This is a common topic. Search web or SO site on the keywords `Allen Browne ConcatRelated function`. – June7 Jul 07 '18 at 01:24
  • I've searched and tried the ConcatRelated function, but can't get it to work. – Cookie28 Jul 07 '18 at 12:27
  • 1
    "Can't get it to work" means what - error message, wrong results, nothing happens? The Allen Browne code is a proven technique. We have no information to assist with your issue. You must provide specifics related to your effort to implement the code. Edit your question. – June7 Jul 08 '18 at 19:08

0 Answers0