Tranform Data Input data to require ouput format

[sgwong]

Output format:

1. Group by Date

2. Eliminate those column A, B, C that row valud is zero

3. Sum of the Count A,B, C

Sample input and output format worksheet as per attach.

[Qiu · Accepted solution]

@sgwong 
We can use the Combination of Transpose and CrossTab for this kindly problem.
My result is a bit different with yours for Column A though. 😁

[TUSHAR050392]

You can use the summarize tool, group the data by Date and sum remaining 4 columns and rename to actual column names. This will provide the output as required