Cross tab

[Feras95p]

Dear all,

I have these type of data as shown in the picture below:-

And I'm looking to have from of the input picture above the output look like the picture below:-

The excel file is attached as well.

Thanks in advance for your kind support

[pedrodrfaria · Accepted solution]

Hi @Feras95p 

Please see attached for the workflow

[pedrodrfaria]

@Feras95p  In case you want to see it with the formatting.

[Qiu]

@Feras95p 
How about something like this?

Hope you will not ask for the particular order of week days? But we can do something about it though.

[Feras95p]

Great ! Thanks a lot !! One more question, if I want to add 5 of the total for example if the total is 7 I want to add 5 so the total should be 12 how can I do that ? 

[pedrodrfaria]

You can update the field in the formula tool to do the Total + 5 based on the column you want to update.

[Qiu · Accepted solution]

@Feras95p 
How about a Multi Field Tool?

[Feras95p]

The problem is that, when I add the formula tool and select for example Sunday's column and write [Sunday]+5 all the cells under the Sunday column will increment by 5. I want only the total of Sunday and other days be increment by 5.