I'm dealing with a data set where some groups of information of are broken out across multiple rows even though they should each be in one single unique row. I'm trying to combine these rows based upon matching text strings in a specific column.
An example intake, where certain users have multiple rows:
User | Service 1 | Service 2 | Service 3 | Service 4 | Total |
Bob | 5 | 1 | 5 | 11 | |
Jack | 3 | 8 | 2 | 2 | 15 |
Jack | 3 | 1 | 4 | 8 | |
Jill | 5 | 2 | 7 | ||
John | 9 | 6 | 7 | 4 | 26 |
Mary | 3 | 9 | 12 | ||
Mary | 3 | 4 | 4 | 3 | 14 |
Note "Jack" and "Mary" have multiple rows despite being the same user. So, I'm trying to get from the above to this:
User | Service 1 | Service 2 | Service 3 | Service 4 | Total |
Bob | 5 | 1 | 5 | 11 | |
Jack | 6 | 9 | 2 | 6 | 23 |
Jill | 5 | 2 | 7 | ||
John | 9 | 6 | 7 | 4 | 26 |
Mary | 3 | 4 | 7 | 12 | 26 |
... Where I've combined the "Jack" and "Mary" rows into a single row for each user--which involves adding the column values from the previous multiple Jack and Mary rows.
I've tried a number of different tools (including Summarize and Formula) but haven't had any luck. I'm assuming there's an easy way to do this, but most of the examples I've found involve keeping values rather than combining them.
I'm a fairly new Alteryx user and may not be asking this question in the right way. Appreciate any guidance anyone can provide.
Solved! Go to Solution.
Perfect, thank you!