Forum Discussion
Combine data column from different table
First add the new column in each table. You should the have 3 tables with 3 columns. All columns have the same column headings
then append the tables into 1 long table.
When end you have 1 table, then unpivot the country and subject columns. When you do this, you will be asked which column to aggregate, and how. Select sum of the numeric column
Select "add custom column"
enter ="my value" in the formula box
Hi Matt
I managed to add custom column as you advised but unfortunately after I try to pivot the first 2 column I didnt get the result that I want.,
What do you mean by "pivot the first 2 columns, with sum on the numeric column"
Do I need to pivot country name column and subject column for all three tables?
And how to do - sum on the numeric column as you advised earlier?
First add the new column in each table. You should the have 3 tables with 3 columns. All columns have the same column headings
then append the tables into 1 long table.
When end you have 1 table, then unpivot the country and subject columns. When you do this, you will be asked which column to aggregate, and how. Select sum of the numeric column