Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
PhillipB
Frequent Visitor

Complicated unpivot

‎12-07-2022 03:10 AM

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. 

Labels:
Message 1 of 3
1,783 Views
0
1 ACCEPTED SOLUTION
ddpl
Solution Sage
Solution Sage

‎12-07-2022 03:23 AM

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

 

ddpl_0-1670412194894.png

View solution in original post

Message 2 of 3
1,772 Views
2 REPLIES 2
PhillipB
Frequent Visitor

‎12-09-2022 03:40 AM

Thanks for the help

Message 3 of 3
1,711 Views
0
ddpl
Solution Sage
Solution Sage

‎12-07-2022 03:23 AM

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

 

ddpl_0-1670412194894.png

Message 2 of 3
1,773 Views

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

View All