Report with columns names in excel

[Lumjing]

Hi I have around 200 columns to compare below is a sample data. Here I am subtracting 10-10_Day and getting the result in 10_Check. When I do the final report please see sample output. it should provide me the row and columns names. Can you please help to achieve this. Have attached the sample data for the same. Thank you. 

Input
Rows	10	10_day	10_Check	20	20_day	20_Check	30	30_day	30_Check
10	1	1	0	1	1	0	1	2	-1
20	2	3	-1	3	3	0	3	3	0
30	9	8	1	8	8	0	8	8	0
40	7	4	3	4	4	0	4	3	1
50	6	6	0	6	6	0	6	6	0
50	4	4	0	4	4	0	4	4	0

Output
Row	Coulmn Name	Actual values	Actual Values 2	Difference
10	30_Check	1	2	-1
20	10_Check	2	3	-1
30	10_Check	9	8	1
40	30_Check	4	3	1

[mceleavey · Accepted solution]

Hi @Lumjing ,

I'm not entirely sure what you're wanting for the output, and I hope I have the logic right, but I've built out the workflow as I understand it:

You may need to change the first two tools to reflect the actual data (I've had to skip the first row, and drop the extra columns).

What this does is Transpose the data into name and value columns, then create a group for each row/day check (groups of three). I've then changed the non-check fields to be Actual and Actual 2. I then filtered and joined to allow for the check fields to be associated with the grouping so I could then cross-tab back while keeping the Check fields as rows.

I then dropped the extra columns and created the difference formula:

I hope this helps.

M.

[Lumjing]

@mceleavey it worked thank you