Forum Discussion

Kimia79's avatar
Kimia79
Frequent Visitor
4 years ago
Solved

Having two table side by side

 Hi,   I have two tables with almost the same data. The first one shows the current Subject pattern, and the second one shows the Online subject.  I need to see these two tables side b...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Kimia79 Just create pivot table based on result table with 'Name' and 'Teacher' on rows, 'Current/Online' and 'Subject' on columns and 'Values' on values (in last message I missed one column you should get in the end result - 'Values').

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Kimia79 You need to create two tables with four fields: "Name", "Teacher", "Subject", "Current/Online".

For that you should unpivot columns with subjects and rename new column as "Subject"; then add new cutom columns "Current/Online" and type in for each table as a value "Current subject pattern" and "Online subject pattern" respectively. After that just append two tables.

Kimia79's avatar
Kimia79
Frequent Visitor
4 years ago

Thanks for your reply. How can I see the information in one table like the third picture I posted?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Kimia79 Just create pivot table based on result table with 'Name' and 'Teacher' on rows, 'Current/Online' and 'Subject' on columns and 'Values' on values (in last message I missed one column you should get in the end result - 'Values').