Forum Discussion
aanmi
Helper I
Helper ICombine 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
aanmiHelper I
Helper IHye Matt
Could you explain how can I add another column with same record for more than 3000 rows for each table?
MattAllington
Community Champion
Community ChampionSelect "add custom column"
enter ="my value" in the formula box