Want to combine 3 sheets of different data with different columns into one sheet or pivot

[WThomson]

I have used different reports to get data from our LMS and want to combine the data into one Excel sheet or pivot.
Example of the data is in the attached file.

Problem:
One sheet has the Org Unit, Position and the assignment profile (or object in LMS used to assign training to the positions / org units.)
One sheet has the assignment profiles and the curriculums that are being assigned.
One sheet has the curriculums and the courses within each curriculum.

Essentially, I'd like to be able to have one sheet that has the Org Unit, Position, curriculums being assigned and the courses within the curriculums. I could then create a pivot.
I've tried including the 3 tables into 1 pivot but because the columns of data and different, I can't see how I can use those 3 tables in the one pivot.

[sandy666]

you mean like this ?

[WThomson]

Thank you Sandy. Yes, this is the type of layout but the data in the pivot example isn't quite accurate. Can you share how you did this so I can have a go and see if I can get the data in the layout I need? Thank you

[sandy666]

try Alt + D + P

another way is Power Query but these three tables will need one common column

[WThomson]

thank you for your quick reply. Will give that a go.

[sandy666]

You are welcome