group rows based on column data

[EJ_Alt]

Hi Guys

i am trying to transform my data below, so that for each client data there is only a single row for each date.

Thanks

EJ

[grossal · Accepted solution]

Hi @EJ_Alt,

you can use the Summarize Tool to achieve this.

Input:

Output:

Sample workflow attached. Let me know what you think.

Best

Alex

[EJ_Alt]

Thanks a lot. That was quick.

[grossal · Accepted solution]

You are welcome!

Would you mind accepting it as a solution? 😃