Forum Discussion
Unpivot Multiple Columns - Desktop
Hi bigdee008
Please check all the applied steps in Query Editor.The last step fill down can be used for other columns you need.
Regards,
Cherie
Wow, that is uh, uh, ugly!! I think I figured out what v-cherch-msft did though. I was able to replicate it in Table24 of attached. Is the file something that you can share? If so, I am fairly certain that I could replicate the procedure. If not, perhaps I could make a video for you that walks you through what was done.
Thanks Greg_Deckler . I can share the file but Im not sure how to do that on this forum.
If you have confirmed your email address, you can attach to a post. Otherwise, most people just use One Drive, Box, etc.
hi Greg_Deckler the data file can be found here,. I have limited it to 2 rows only but kept all the colums in.
Hi bigdee008
Please check all the applied steps in Query Editor.The last step fill down can be used for other columns you need.
Regards,
Cherie
Thanks a lot v-cherch-msft I attempted changing the source in the file you shared, however, I am ending up with an error in the Advanced Query Editory everytime. As bizzare as this may sound, i spent the entire day on this yesterday.