Need help with multiple duplicate value in one single cell

Copper Contributor

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.

 

957.jpg

1 Reply

Hi

 

 JSON data ?

 

Import in PowerQuery

2023-03-31 07_24_34-Window.png

Transform >JSON

2023-03-31 07_19_41-Window.png

 

@Zet_Zet