Summarizing Data - Pivoting

[mcarvalho]

Hi all,

this one is quite easy for you.

I have a dataset in the following format:

I want to change it for this format:

Any suggestions on how to do it? I tried through the Transpose but didn't figure it out.

Thanks!

[mcarvalho]

I've already solved it. Thanks!

[JagdeeshN]

Hi @mcarvalho ,

The CrossTab tool should do the trick for you.

Please find attached a sample workflow. Do let me know if this resolves your query.

Best,

Jagdeesh