I'm trying to make a pivot table that can combine the data from 2 columns.
Attached is the raw data.
Basically we have 12 machine broken into 4 groups (line 1 & 2 each with set 1 & 2)
So each group has a Bonder 1, Bonder 2, and Bonder 3
We do 2 types of test (WBP and Alum Pad) and we do each test 2 times (see columns labeled T1 & T2 for each bonder)
I need the average and standard deviation for each test type, broken down by each machine.
My main problem is getting the pivot table to combine the results of 2 columns (the 2 tests) into a single average/stddev result (broken down by machine).
I got it done on the calculated results tab using some very complicated database formulas.
I just want to know if I could have done it with a pivot table.