Help with creating an advance Table

[martina15]

I have attached an excel with a few rows of sample data and a pivot table.

How can I create in Alteryx a table that looks like the one on my attached excel file if I have to show the id of the worker and how many categories belong to that worker if the worker id is repeated in same category, If someone looks at the pivot table you will understand how I want the table to look like

Thanks

FLOR

[binuacs]

@martina15 one way of doing this

[martina15]

thanks for the answer. However, when I do this with my real data is says and change ID workder with nameID it says:

## Record #1: Tool #2: the field "nameID" is missing. Compared the tool configuration with the input stream###

[binuacs]

@martina15 can you provide some dummy data with real column names

[martina15]

The data look like this 

I did changed the names and also I add a question on the excel. thanks for the help

[martina15]

Please check my question also via Lindkln

[binuacs]

@martina15 attaching the updated workflow based on the raw data