Summarize information into chart

[Becky]

I want to summarize information into chart but it is difficult for me...

Could you kindly help to build this flow? Thanks.

[aish49]

Hi !

This is the most that I could do. Since, it can't have more than one set of headers, you can use the first two columns as your headers while taking the output in whichever visualisation tool that you're using.

Check out the workflow in the attachment.

Let me know if there is more that I can do to help you :)

[DavidP]

This is how I would approach arranging the columns - you then just have to tidy up your column names. 

[danilang · Accepted solution]

hi @Becky 

Building on the work of @DavidP(who did all the heavy lifting), here's a version that breaks out the column headers into 3 separate rows.

Dan

[DavidP]

Teamwork!

[Becky]

Dear all,

Thank you very much and sorry for my late reply.

FInally, I can make result with your advice!!! Best regards.