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
Nope, not clear yet, let's try this:
Source data looks like:
A,B,C,D1,D2,D3,E1,E2,E3
bob,b1,c1,d1,d12,d13,e1,e12,e13
suzy,b2,c2,d2,d22,d23,e2,e22,e23
And I want it to end up like:
A,B,C,D,E
bob,b1,c1,d1,e1
bob,b1,c1,d12,e12
bob,b1,c1,d13,e13
suzy,b2,c2,d2,e2
suzy,b2,c2,d22,e22
suzy,b2,c2,d23,e23
Is that correct? If not, provide an example, with data for your source and your output, it's the only way to be clear.
bigdee008 - can you provide actual data example like above?
Hi Greg_Deckler Please see my screenshot below
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.