0

I have a data like this:

    date      id      product
29-01-16    1       a
29-01-16    1       b
29-01-16    1       c

I have created uniq_id as id_date. I want the output like

uniq_id       products
1_29-01-16    a,b,c
Marta
  • 3,032
  • 3
  • 17
  • 34
Anusua Mukherjee
  • 1
  • 2
  • 2
    The number of time this question has been asked and either answered or marked as a duplicate must be at least 10. Yeah, that's a pretty good dupe. – IRTFM Jan 29 '16 at 07:37
  • I think this Q&A is worth linking to as well, as it contains some additional alternatives: [Collapse / concatenate / aggregate a column to a single comma separated string within each group](http://stackoverflow.com/questions/15933958/collapse-concatenate-aggregate-a-column-to-a-single-comma-separated-string-w) – Henrik Jan 29 '16 at 10:15

0 Answers0