cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Junaid11
Helper IV
Helper IV

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 IV
Helper IV

1 REPLY 1
Junaid11
Helper IV
Helper IV

I solved it using below video

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors