Hi,
I have a table of values approximately 1000 rows and 10 columns. Columns 2-10 are numerical values and column 1 is the policy number.
The policy number repeats for certain numbers so there are maybe 700 unique policy numbers in column 1. How do I transform the table so there is a single policy number and columns 2 - 10 are combined.
So the same policy number in cells A1 and A2 would combine into a single row and add B1+B2 together.
We would end up with a table of 700 rows and columns B - K using the totals.
Thanks,
I have a table of values approximately 1000 rows and 10 columns. Columns 2-10 are numerical values and column 1 is the policy number.
The policy number repeats for certain numbers so there are maybe 700 unique policy numbers in column 1. How do I transform the table so there is a single policy number and columns 2 - 10 are combined.
So the same policy number in cells A1 and A2 would combine into a single row and add B1+B2 together.
We would end up with a table of 700 rows and columns B - K using the totals.
Thanks,