Groupby operation on text data

[Minakshi]

Hi Experts,

I have the following data 

Shop ID	Date	Attendance	Image link
1	2/12/2021	1	img1
1	2/12/2021	1	img2
1	2/12/2021	1	img3

I want to convert this data into following foramt

Shop ID	Date	Attendance	image link 1	image link 2	image link3
1	2/12/2021	1	img1	img2	img3

Kindly suggest the possible way to do this.
Thanks

[Anonymous · Accepted solution]

Hi @Minakshi ,

Step1:

Copy and paste table as table2.

Step2:

Remove other columns except image_link column in table2.

Step3:

transpose table2.

Step4:

Merge table1 and table2 as new and remove empty rows.

Pbix as attached.

Best Regards,

Jay

[amitchandak]

@Minakshi , Unpivot the data with Max

https://radacad.com/pivot-and-unpivot-with-power-bi

or in matrix visual use Img link as column and value(max)