Forum Discussion

adm010's avatar
adm010
Microsoft Employee
5 years ago
Solved

Separating CSV values generated by a picklist

Hi everyone.   Newbie question.  Have imported a load of data from Azure Devops.  Within Devops, there was a picklist to pick a number of apps used on each project.  When exported, these appear as ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    adm010  If you're importing the data you can use Power Query to split the column. Click 'Transform Data' in the Home tab in the ribbon, then select 'Transform' tab in ribbon. Then Split Column. You can expand advanced and split into rows instead of columns too. 

     

    Does that help? Let me know if you need more info. 

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

adm010  If you're importing the data you can use Power Query to split the column. Click 'Transform Data' in the Home tab in the ribbon, then select 'Transform' tab in ribbon. Then Split Column. You can expand advanced and split into rows instead of columns too. 

 

Does that help? Let me know if you need more info. 

  • adm010's avatar
    adm010
    Microsoft Employee
    5 years ago

    Hey Allison,

     

    Thanks so much for taking the time to help me out 🙂

     

    Follow up if thats ok - So ive split the data into a couple of columns and now in my Fields tab can see column 1 and column 2.  What i need to do now is show both columns data in one combined chart - ie so i can see the number of each picklist item ive now seporated out.  I can create a chart to show one or the other, but not sure on how to combine them together?