Forum Discussion

Minakshi's avatar
Minakshi
Resolver I
5 years ago
Solved

Groupby operation on text data

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 ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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