Need help with multiple duplicate value in one single cell

Occasional Visitor

Hi there,


I am trying to look for exactly some value in my excel worksheet. Each cell in my sheet contains these line, I just want to take some information from this cell. For example, in the attached image, I want these information: "Loki" "11-28-10" "Kevin " "2-10-12" "Dravin " "8-17-12" "Melodie" "11-13-13""Sage ""12-4-14""Willow ""6-21-16". 

looking for many solutions but didn't work


Any suggestions?


Many thanks.



1 Reply



 JSON data ?


Import in PowerQuery

2023-03-31 07_24_34-Window.png

Transform >JSON

2023-03-31 07_19_41-Window.png