Concating every duplicate record

[Alteryxuserhere]

Hi All

I have the following dataset

ID	Food	Expiry Date
12345	Tomato	12 Jan
67890	Potato	23 Dec
53235	Cauliflower	8 Aug
12345	Pizza	6 June

How do I concat the Food and Expiry Date Collumn together so I can create a new collumn based on the ID and have the Expiry Date and Food collumn merged together per ID value?  and then sort the concated values by order of date?

So i want to create something like the below

ID	Food	Expiry Date	Concated Values
12345	Tomato	12 Jan	12 Jan_Tomato | 6 June_Pizza
67890	Potato	23 Dec	23 Dec_Potato
53235	Cauliflower	8 Aug	8 Aug_Cauliflower
12345	Pizza	6 June	12 Jan_Tomato | 6 June_Pizza

Thanks in advance!

[JosephSerpis · Accepted solution]

Hi @Alteryxuserhere you can you the summarise tool to concatenate your data then use the join tool to join the concatenated date back onto your orginal data. I have mocked up an approach which shows this.

[Alteryxuserhere]

Many thanks @JosephSerpis , can you explain the purpose of the record ID step? 

[JosephSerpis]

Hi @Alteryxuserhere that is to sort your data back to what it looked like from the input.