Mergeing Three Tables

[Anonymous]

Hello everyone,

I've been trying to work with a data example for over an hour now, but I can't seem to get it to look the way I want it to. My latest attempt involved 600 movie titles, but I only ended up with around 547 rows. I would greatly appreciate it if someone could provide some simple explanations of the step-by-step process to follow in order to successfully merge, unpivot, and possibly remove some rows from the data to create a final table with 600 rows and 4 columns.

Thank you in advance for any assistance you can provide!

Example results:

Currently what mine looks like:

[PhilipTreacy]

Hi @Anonymous 

Pretty much impossible to help you without the data you are using and knowing exactly what it is you are trying to achieve.

regards

Phil