Combine 2 rows

[adamd]

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

[LordNeilLord · Accepted solution]

Hello back @adamd

Summarize for the win!

[adamd]

Thanks! Perfect.
Curious... would I have been able to arrive at a similar result on the path I was on? Cross-tab/transpose and or formula tool?
Just learning. Thanks!