cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.