Data format

Hello vinb4u2,

1. Load your table into Power Query Editor by selecting "Edit Queries" from the Home tab in Power BI Desktop.

2. Select your table and click on the "Group By" button in the "Transform" tab.

3. In the "Group By" dialog box, select "Appid" as the "Group by" column.

4. In the "New column name" field, enter "OS" (or any name you prefer).

5. In the "Operation" column, select "All Rows".

6. Click "OK" to apply the changes.

7. This will create a new table with a column for "Appid" and a column for "OS" where the values in the "OS" column are concatenated for each "Appid".