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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Junaid11
Helper V
Helper V

All other same columns to single column

Hello,

I have a table which has same column name but each repeating column represents a service. Like if purchases column is coming first time it shows purchase of first service similarly if purchase column comes second time then it shows purchase of second service. I am attaching the table along with the outcome I want to have. I have tried unpivoting but did not get desired result. 

My table look like below:

 1  2  3  
Client namePurchase AB//ACBooking DatePurchase AB//ACBooking DatePurchase AB//ACBooking Date
1$32,400AB28/12/2021      
2$150,720AC30/09/2019$54,600AC23/10/2020$11,000AC18/12/2019
3$9,192AC05/02/2020$24,005AC02/02/2021$0AB18/02/2021
4$90,000AB02/11/2020$42,500AB24/09/2020$42,500AC26/09/2020
5$60,180AC01/09/2021$15,912AB02/12/2021   
6$72,563AC20/03/2020$14,000AC14/04/2020$65,862AB31/03/2021

1,2,3 on top of column shows service for each like purchase for service 1, then 2 and then 3rd.

asfeeggg.PNG

My outcome look like this:

Client namePurchase AB//ACBooking Date
1$32,400AB28/12/2021
2$150,720AC30/09/2019
3$9,192AC05/02/2020
4$90,000AB02/11/2020
5$60,180AC01/09/2021
6$72,563AC20/03/2020
1   
2$54,600AC23/10/2020
3$24,005AC02/02/2021
4$42,500AB24/09/2020
5$15,912AB02/12/2021
6$14,000AC14/04/2020
1   
2$11,000AC18/12/2019
3$0AB18/02/2021
4$42,500AC26/09/2020
5   
6$65,862AB31/03/2021

It would be quite helpful if it is possible or not.

Thank you

1 ACCEPTED SOLUTION
Junaid11
Helper V
Helper V

1 REPLY 1
Junaid11
Helper V
Helper V

I solved it using below video

https://www.youtube.com/watch?v=aTXQ77Vf5Gc

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.