SOLVED
Reformatting table
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
murrayjl03
7 - Meteor
‎07-01-2019
05:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 🙂
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
- Workflow
2 REPLIES 2
DataKyle
8 - Asteroid
‎07-01-2019
05:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ChrisTX
16 - Nebula
‎07-01-2019
05:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.