E
Ember
Hi,
I currently have data that looks something like
A | B | C
1 | 1 | 5
1 | 2 | 9
2 | 1 | 7
2 | 2 | 4
(but obviosuly many times bigger)
If I put this in a pivot table, with A and B on the axis, it would loo
something like:
_ | 1 | 2
1 | 5 | 9
2 | 7 | 4
This is because it counts (1,2) as different from (2,1). Is there an
way to concatonate the two? i.e.:
_ | 1 | 2
1 | 5 |
2 | 8 | 4
Let me knwo if this doesn't make sense.
Thanks
I currently have data that looks something like
A | B | C
1 | 1 | 5
1 | 2 | 9
2 | 1 | 7
2 | 2 | 4
(but obviosuly many times bigger)
If I put this in a pivot table, with A and B on the axis, it would loo
something like:
_ | 1 | 2
1 | 5 | 9
2 | 7 | 4
This is because it counts (1,2) as different from (2,1). Is there an
way to concatonate the two? i.e.:
_ | 1 | 2
1 | 5 |
2 | 8 | 4
Let me knwo if this doesn't make sense.
Thanks