Create Columns for Each Metric

[KamenRider]

Hi,

Can someone to please share his expertise and ideas on how I am going to make a field from rows to columns? I have this Metric Green, Amber and Red in a column and would like to arrange the data separately column. One column for Green, a column for Amber and a column for RED. below is the raw data.

Somehow this output should look like this.

 

Appreciate your help on this.

Thanks,

Kamen

 

[KamenRider]

Attaching sample input file for your reference.

[binuacs]

@KamenRider you need to adjust the formatting in the workflow to align with the table columns

[KamenRider]

Thank you @binuacs  for this ideas. Just one favor, the total percentage for Xcol_Amber, Green and Red does not match with my sample. The percentage total is taken from the overall total percentage. Can you please made some update?

Thanks and looking forward for your continued assistance.

Kamen

[binuacs · Accepted solution]

@KamenRider 

[KamenRider]

Thanks @binuacs . You are remarkable.

Kamen