Forum Discussion
Solved
Combine data column from different table
Hi May I know is there any way to combine same data column into one table? For example I have created three different table as below and I want to combine all data to be visualize i...
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
For each table, add a new column identifying the table (either Maths, science, physics)
call this column "subject" in all cases
append the 3 tables together
pivot the first 2 columns, with sum on the numeric column
Hye Matt
Could you explain how can I add another column with same record for more than 3000 rows for each table?