Extract data in serialized column to new column

[santhiya]

Hi Community!!!

I am having a column named "changes " and contains following value a:2:{s:4:"fruits";s:5:"Apple";s:4:"Flower";s:5:"Rose"}. I need to extract fruits and Flower as separate column which should contain Apple and Rose respectively . Since my column contains serialized PHP object I am not sure how to deserialize as separate column in Power BI

Thanks

[santhiya]

Hi @Ahmedx  Thanks for you time, This is not what i expect . The value should be extracted into new column with the key as column header 
eg: 
Fruit   Flower
Apple Rose 
Note: some time the key position may also change 



      Apple

[Ahmedx]

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhjXP3KEeQHLLXfH4?e=5Z03AC

[Ahmedx]