Hello!
I am new here and really trying to get past some specific barriers.
My question is totally newb, but that's ok. Asking anyway!
Item | V_1 | V_2 | V_3 |
A | 2 | 3 | 4 |
B | 4 | 2 | 5 |
I simply want to combine these two rows into one as one item and sum the rows in V_* to each their own values so:
Item | V_1_sum | V_2_sum | V_3_sum |
AB | 6 | 5 | 9 |
I've been struggling to determine if I should be trying to use the Cross-tab and transpose together somehow, or even the formula tool.
I have not mastered the cross-tab/transpose tools though they seem to be calling me to use in this scenario.
Help! haha I want to know how to do this!
Thank you:)
Solved! Go to Solution.