Reformatting table

[murrayjl03]

Hi!

I have a scenario where i have a list of categories and subcategories which appear for various dates, i want to take this data and simplify so i can see of each category/subcategory all the dates that appear in a single cell.

Example data:

Category	Subcategory	Date
1	a	30/01/2018 00:00
1	c	30/01/2018 00:00
1	b	30/01/2018 00:00
1	a	27/02/2018 00:00
1	c	27/02/2018 00:00
1	b	27/02/2018 00:00
1	a	27/04/2018 00:00
1	c	27/04/2018 00:00
1	b	27/04/2018 00:00
1	a	30/05/2018 00:00
1	c	30/05/2018 00:00
1	b	30/05/2018 00:00
2	a	30/01/2018 00:00
2	c	30/01/2018 00:00
2	b	30/01/2018 00:00
2	a	27/02/2018 00:00
2	c	27/02/2018 00:00
2	b	27/02/2018 00:00
2	a	27/04/2018 00:00
2	c	27/04/2018 00:00

My desired outcome would show the data like:

Category	Subcategory	Date
1	a	27/02/2018, 27/04/2018, 30/05/2018
1	c	27/02/2018, 27/04/2018, 30/05/2018
1	b	27/02/2018, 27/04/2018, 30/05/2018
2	a	30/01/2018, 27/02/2018, 27/04/2018
2	c	30/01/2018, 27/02/2018, 27/04/2018
2	b	30/01/2018, 27/02/2018, 27/04/2018

Thanks for any help

[murrayjl03]

Hi!

I have a scenario where i have a list of categories and subcategories which appear for various dates, i want to take this data and simplify so i can see of each category/subcategory all the dates that appear in a single cell.

Example data:

Category	Subcategory	Date
1	a	30/01/2018 00:00
1	c	30/01/2018 00:00
1	b	30/01/2018 00:00
1	a	27/02/2018 00:00
1	c	27/02/2018 00:00
1	b	27/02/2018 00:00
1	a	27/04/2018 00:00
1	c	27/04/2018 00:00
1	b	27/04/2018 00:00
1	a	30/05/2018 00:00
1	c	30/05/2018 00:00
1	b	30/05/2018 00:00
2	a	30/01/2018 00:00
2	c	30/01/2018 00:00
2	b	30/01/2018 00:00
2	a	27/02/2018 00:00
2	c	27/02/2018 00:00
2	b	27/02/2018 00:00
2	a	27/04/2018 00:00
2	c	27/04/2018 00:00

My desired outcome would show the data like:

Category	Subcategory	Date
1	a	27/02/2018, 27/04/2018, 30/05/2018
1	c	27/02/2018, 27/04/2018, 30/05/2018
1	b	27/02/2018, 27/04/2018, 30/05/2018
2	a	30/01/2018, 27/02/2018, 27/04/2018
2	c	30/01/2018, 27/02/2018, 27/04/2018
2	b	30/01/2018, 27/02/2018, 27/04/2018

Thanks for any help

[DataKyle]

How does this look?

[ChrisTX · Accepted solution]

Use the Summarize tool.  Group by your Category and Subcategory fields.  Select the Date field at the top, then at the bottom choose String > Concatenate.

You'll need to strip off your 00:00 time first.