topic All other same columns to single column in Desktop
https://community.powerbi.com/t5/Desktop/All-other-same-columns-to-single-column/m-p/2518251#M894248
<P>Hello,</P><P>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. </P><P>My table look like below:</P><TABLE border="1"><TBODY><TR><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD>2</TD><TD> </TD><TD> </TD><TD>3</TD><TD> </TD><TD> </TD></TR><TR><TD>Client name</TD><TD>Purchase </TD><TD>AB//AC</TD><TD>Booking Date</TD><TD>Purchase </TD><TD>AB//AC</TD><TD>Booking Date</TD><TD>Purchase </TD><TD>AB//AC</TD><TD>Booking Date</TD></TR><TR><TD>1</TD><TD>$32,400</TD><TD>AB</TD><TD>28/12/2021</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>$150,720</TD><TD>AC</TD><TD>30/09/2019</TD><TD>$54,600</TD><TD>AC</TD><TD>23/10/2020</TD><TD>$11,000</TD><TD>AC</TD><TD>18/12/2019</TD></TR><TR><TD>3</TD><TD>$9,192</TD><TD>AC</TD><TD>05/02/2020</TD><TD>$24,005</TD><TD>AC</TD><TD>02/02/2021</TD><TD>$0</TD><TD>AB</TD><TD>18/02/2021</TD></TR><TR><TD>4</TD><TD>$90,000</TD><TD>AB</TD><TD>02/11/2020</TD><TD>$42,500</TD><TD>AB</TD><TD>24/09/2020</TD><TD>$42,500</TD><TD>AC</TD><TD>26/09/2020</TD></TR><TR><TD>5</TD><TD>$60,180</TD><TD>AC</TD><TD>01/09/2021</TD><TD>$15,912</TD><TD>AB</TD><TD>02/12/2021</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>6</TD><TD>$72,563</TD><TD>AC</TD><TD>20/03/2020</TD><TD>$14,000</TD><TD>AC</TD><TD>14/04/2020</TD><TD>$65,862</TD><TD>AB</TD><TD>31/03/2021</TD></TR></TBODY></TABLE><P>1,2,3 on top of column shows service for each like purchase for service 1, then 2 and then 3rd.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asfeeggg.PNG" style="width: 999px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/715885i9639421A431419F2/image-size/large?v=v2&px=999" role="button" title="asfeeggg.PNG" alt="asfeeggg.PNG" /></span></P><P>My outcome look like this:</P><TABLE border="1"><TBODY><TR><TD>Client name</TD><TD>Purchase </TD><TD>AB//AC</TD><TD>Booking Date</TD></TR><TR><TD>1</TD><TD>$32,400</TD><TD>AB</TD><TD>28/12/2021</TD></TR><TR><TD>2</TD><TD>$150,720</TD><TD>AC</TD><TD>30/09/2019</TD></TR><TR><TD>3</TD><TD>$9,192</TD><TD>AC</TD><TD>05/02/2020</TD></TR><TR><TD>4</TD><TD>$90,000</TD><TD>AB</TD><TD>02/11/2020</TD></TR><TR><TD>5</TD><TD>$60,180</TD><TD>AC</TD><TD>01/09/2021</TD></TR><TR><TD>6</TD><TD>$72,563</TD><TD>AC</TD><TD>20/03/2020</TD></TR><TR><TD>1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>$54,600</TD><TD>AC</TD><TD>23/10/2020</TD></TR><TR><TD>3</TD><TD>$24,005</TD><TD>AC</TD><TD>02/02/2021</TD></TR><TR><TD>4</TD><TD>$42,500</TD><TD>AB</TD><TD>24/09/2020</TD></TR><TR><TD>5</TD><TD>$15,912</TD><TD>AB</TD><TD>02/12/2021</TD></TR><TR><TD>6</TD><TD>$14,000</TD><TD>AC</TD><TD>14/04/2020</TD></TR><TR><TD>1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>$11,000</TD><TD>AC</TD><TD>18/12/2019</TD></TR><TR><TD>3</TD><TD>$0</TD><TD>AB</TD><TD>18/02/2021</TD></TR><TR><TD>4</TD><TD>$42,500</TD><TD>AC</TD><TD>26/09/2020</TD></TR><TR><TD>5</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>6</TD><TD>$65,862</TD><TD>AB</TD><TD>31/03/2021</TD></TR></TBODY></TABLE><P>It would be quite helpful if it is possible or not.</P><P>Thank you</P>Mon, 16 May 2022 16:35:25 GMTJunaid112022-05-16T16:35:25ZAll other same columns to single column
https://community.powerbi.com/t5/Desktop/All-other-same-columns-to-single-column/m-p/2518251#M894248
<P>Hello,</P><P>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. </P><P>My table look like below:</P><TABLE border="1"><TBODY><TR><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD>2</TD><TD> </TD><TD> </TD><TD>3</TD><TD> </TD><TD> </TD></TR><TR><TD>Client name</TD><TD>Purchase </TD><TD>AB//AC</TD><TD>Booking Date</TD><TD>Purchase </TD><TD>AB//AC</TD><TD>Booking Date</TD><TD>Purchase </TD><TD>AB//AC</TD><TD>Booking Date</TD></TR><TR><TD>1</TD><TD>$32,400</TD><TD>AB</TD><TD>28/12/2021</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>$150,720</TD><TD>AC</TD><TD>30/09/2019</TD><TD>$54,600</TD><TD>AC</TD><TD>23/10/2020</TD><TD>$11,000</TD><TD>AC</TD><TD>18/12/2019</TD></TR><TR><TD>3</TD><TD>$9,192</TD><TD>AC</TD><TD>05/02/2020</TD><TD>$24,005</TD><TD>AC</TD><TD>02/02/2021</TD><TD>$0</TD><TD>AB</TD><TD>18/02/2021</TD></TR><TR><TD>4</TD><TD>$90,000</TD><TD>AB</TD><TD>02/11/2020</TD><TD>$42,500</TD><TD>AB</TD><TD>24/09/2020</TD><TD>$42,500</TD><TD>AC</TD><TD>26/09/2020</TD></TR><TR><TD>5</TD><TD>$60,180</TD><TD>AC</TD><TD>01/09/2021</TD><TD>$15,912</TD><TD>AB</TD><TD>02/12/2021</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>6</TD><TD>$72,563</TD><TD>AC</TD><TD>20/03/2020</TD><TD>$14,000</TD><TD>AC</TD><TD>14/04/2020</TD><TD>$65,862</TD><TD>AB</TD><TD>31/03/2021</TD></TR></TBODY></TABLE><P>1,2,3 on top of column shows service for each like purchase for service 1, then 2 and then 3rd.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asfeeggg.PNG" style="width: 999px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/715885i9639421A431419F2/image-size/large?v=v2&px=999" role="button" title="asfeeggg.PNG" alt="asfeeggg.PNG" /></span></P><P>My outcome look like this:</P><TABLE border="1"><TBODY><TR><TD>Client name</TD><TD>Purchase </TD><TD>AB//AC</TD><TD>Booking Date</TD></TR><TR><TD>1</TD><TD>$32,400</TD><TD>AB</TD><TD>28/12/2021</TD></TR><TR><TD>2</TD><TD>$150,720</TD><TD>AC</TD><TD>30/09/2019</TD></TR><TR><TD>3</TD><TD>$9,192</TD><TD>AC</TD><TD>05/02/2020</TD></TR><TR><TD>4</TD><TD>$90,000</TD><TD>AB</TD><TD>02/11/2020</TD></TR><TR><TD>5</TD><TD>$60,180</TD><TD>AC</TD><TD>01/09/2021</TD></TR><TR><TD>6</TD><TD>$72,563</TD><TD>AC</TD><TD>20/03/2020</TD></TR><TR><TD>1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>$54,600</TD><TD>AC</TD><TD>23/10/2020</TD></TR><TR><TD>3</TD><TD>$24,005</TD><TD>AC</TD><TD>02/02/2021</TD></TR><TR><TD>4</TD><TD>$42,500</TD><TD>AB</TD><TD>24/09/2020</TD></TR><TR><TD>5</TD><TD>$15,912</TD><TD>AB</TD><TD>02/12/2021</TD></TR><TR><TD>6</TD><TD>$14,000</TD><TD>AC</TD><TD>14/04/2020</TD></TR><TR><TD>1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>$11,000</TD><TD>AC</TD><TD>18/12/2019</TD></TR><TR><TD>3</TD><TD>$0</TD><TD>AB</TD><TD>18/02/2021</TD></TR><TR><TD>4</TD><TD>$42,500</TD><TD>AC</TD><TD>26/09/2020</TD></TR><TR><TD>5</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>6</TD><TD>$65,862</TD><TD>AB</TD><TD>31/03/2021</TD></TR></TBODY></TABLE><P>It would be quite helpful if it is possible or not.</P><P>Thank you</P>Mon, 16 May 2022 16:35:25 GMThttps://community.powerbi.com/t5/Desktop/All-other-same-columns-to-single-column/m-p/2518251#M894248Junaid112022-05-16T16:35:25ZRe: All other same columns to single column
https://community.powerbi.com/t5/Desktop/All-other-same-columns-to-single-column/m-p/2518673#M894367
<P>I solved it using below video</P><P><A href="https://www.youtube.com/watch?v=aTXQ77Vf5Gc" target="_blank">https://www.youtube.com/watch?v=aTXQ77Vf5Gc</A></P>Mon, 16 May 2022 20:32:23 GMThttps://community.powerbi.com/t5/Desktop/All-other-same-columns-to-single-column/m-p/2518673#M894367Junaid112022-05-16T20:32:23Z