All other same columns to single column

[Junaid11]

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 name	Purchase	AB//AC	Booking Date	Purchase	AB//AC	Booking Date	Purchase	AB//AC	Booking Date
1	$32,400	AB	28/12/2021
2	$150,720	AC	30/09/2019	$54,600	AC	23/10/2020	$11,000	AC	18/12/2019
3	$9,192	AC	05/02/2020	$24,005	AC	02/02/2021	$0	AB	18/02/2021
4	$90,000	AB	02/11/2020	$42,500	AB	24/09/2020	$42,500	AC	26/09/2020
5	$60,180	AC	01/09/2021	$15,912	AB	02/12/2021
6	$72,563	AC	20/03/2020	$14,000	AC	14/04/2020	$65,862	AB	31/03/2021

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

My outcome look like this:

Client name	Purchase	AB//AC	Booking Date
1	$32,400	AB	28/12/2021
2	$150,720	AC	30/09/2019
3	$9,192	AC	05/02/2020
4	$90,000	AB	02/11/2020
5	$60,180	AC	01/09/2021
6	$72,563	AC	20/03/2020
1
2	$54,600	AC	23/10/2020
3	$24,005	AC	02/02/2021
4	$42,500	AB	24/09/2020
5	$15,912	AB	02/12/2021
6	$14,000	AC	14/04/2020
1
2	$11,000	AC	18/12/2019
3	$0	AB	18/02/2021
4	$42,500	AC	26/09/2020
5
6	$65,862	AB	31/03/2021

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

Thank you

[Junaid11 · Accepted solution]

I solved it using below video

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