Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PhillipB
Frequent Visitor

Complicated unpivot

I have a set of data that needs to take several columns bring them all in to one column but also then to copy the data from the other columns that they match and copy it down.

 

The data initially reads like this:

 

        Date 1 Date 2 Date 3
XX234 XX235 XX236 XX279 21/11/2022 22/11/2022 23/11/2022
XY236 XZ235 YX236 XT279 22/11/2022 26/11/2022 31/11/2022
XB234 XB235 XX238 XV279 21/11/2022 24/11/2022 25/11/2022
RX244 RX235 YX236 PX279 22/11/2022 23/11/2022 23/11/2022

 

And it needs to ready like this

          Date 1 Date 2 Date 3
XX234 21/11/2022 22/11/2022 23/11/2022
XY236 22/11/2022 26/11/2022 31/11/2022
XB234 21/11/2022 24/11/2022 25/11/2022
RX244 22/11/2022 23/11/2022 23/11/2022
XX235 21/11/2022 22/11/2022 23/11/2022
XZ235 22/11/2022 26/11/2022 31/11/2022
XB235 21/11/2022 24/11/2022 25/11/2022
RX235 22/11/2022 23/11/2022 23/11/2022
XX236 21/11/2022 22/11/2022 23/11/2022
YX236 22/11/2022 26/11/2022 31/11/2022
XX238 21/11/2022 24/11/2022 25/11/2022
YX236 22/11/2022 23/11/2022 23/11/2022
XX279 21/11/2022 22/11/2022 23/11/2022
XT279 22/11/2022 26/11/2022 31/11/2022
XV279 21/11/2022 24/11/2022 25/11/2022
PX279 22/11/2022 23/11/2022 

23/11/2022

 

 

Column 2-4 is moved down sequentially with the dates information then also copied down in to the columns to maintain the relationship. 

1 ACCEPTED SOLUTION
ddpl
Solution Sage
Solution Sage

@PhillipB try "unpivot only selected column"as per below

 

ddpl_0-1670412194894.png

View solution in original post

2 REPLIES 2
PhillipB
Frequent Visitor

Thanks for the help

ddpl
Solution Sage
Solution Sage

@PhillipB try "unpivot only selected column"as per below

 

ddpl_0-1670412194894.png

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.