Column From Examples, in Power Query, keeps blowing our mind! Patrick shows you an example where he wanted to extract some data. Will Column From Examples work? Of course, it will! Check this out!
Add a column from examples in Power BI Desktop
https://docs.microsoft.com/power-bi/create-reports/desktop-add-column-from-example