Forum Discussion
vinb4u2
3 years agoRegular Visitor
Data format
I have table like below Appid OS APP0005 WINDOWS SERVER 2012 DATA CENTER APP0005 WINDOWS SERVER 2016 APP0005 WINDOWS SERVER 2019 APP0006 WINDOWS SERVER 2012 R2 STANDARD ...
Sahir_Maharaj
3 years agoSuper User
To format the "OS" column with comma-separated values, select the column and click on the "Split Column" button in the "Transform" tab.
In the "Split Column" dialog box, select "Custom" as the "Split type" and enter a comma "," as the delimiter.
This will split the "OS" column into multiple columns with the same name.
Finally, select all the new "OS" columns and click on the "Merge Columns" button in the "Transform" tab.
In the "Merge Columns" dialog box, select a comma "," as the delimiter and enter "OS" as the new column name.
Click "OK" to apply the changes.
This should give you the desired format. Let me know if you might require further assistance.
vinb4u2
3 years agoRegular Visitor
Hi Sahir,
For some reason Merge option not enabled in my power BI desktop