Hi
Input :
Name | Data |
A | Monday |
A | Tuesday |
A | Wednesday |
B | Monday |
B | Tuesday |
B | Wednesday |
Output:
Name | Data |
A | Monday,Tuesday,Wednesday |
B | Monday,Tuesday,Wednesday |
Solved! Go to Solution.
Use summarize, and then select group by your main grouping value, and concatenate the rest! Hope this helps!