How to capture in chart?

[FcwfCW76]

Hello

I have a table

FcwfCW76_0-1646241245201.png

I want this

FcwfCW76_1-1646241459438.png

I am not sure which tool (chart, table anything else) and arguments would be best to explore and learn in order to get the result I want.
Do you have any advice?

Thank you.

[somesoni2]

Could you provide more details on the logic here?

[ITWhisperer · Accepted solution]

Assuming you can split your project names with underscores (and that you really meant A_2/a_2 etc)

| eval project_number=mvindex(split(project,"_"),1)
| eventstats values(project) as project by project_number
| fields - project_number
| eval project=mvjoin(project,"/")
| stats list(*) as * by project
| foreach category*
    [| eval <<FIELD>>=mvjoin(<<FIELD>>,"/")]