Forum Discussion
Problems with unpivoting multiple column value pairs
FYI that I was not able to modify your query as it references a file on your local drive. However, FYI that this YoutTube video covers how to handle this scenario. There is a file you can download too, if needed.
Faster Data Transformations with List/Record M Functions - YouTube
Pat
Hi Pat,
Thanks a lot for your help! Hmm, alright - I'll try another file sharing solution next time.
Before I got a chance to watch your linked video, I actually managed to solve the issue myself in a quite simple way. I am not sure it might be the best solution for all similar problems, but for those who might be interested, this is how I did it:
1. I merged main supplier with main supplier ID, sub-supplier with sub-supplier IDand over-supplier with over-supplier ID (I used a pipe symbol as delimiter):
2. I unpivoted the three newly merged columns at once and changed the header names: