Folks, How do you join two tables between two sheets which are rows vs columns and generate a table for combination data graphs.
Attached sheet as reference.
Content1 sheet has multiple Methods for Topics in columns
Content2 sheet has Methods and sub-methods in rows
So, I tried to create a join sheet before coming up with a centralized data sheet for all combinatoric graphs.
I have tried various ways and now using BI to join the sheets by re-doing the data and this certainly is not going to help in long term.
Any help appreciated.
Bookmarks