Forum Discussion
Anonymous
3 years agoNot applicable
Mergeing Three Tables
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:
1 Reply
- PhilipTreacySuper User
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