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!
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:)
