Dec 21 2022 07:52 AM
Hello All,
Pl help
I get a CSV where one column has got all tags extracted data with values. the values starts with @{ all values seperated by ; } the data is seperated by semi colan ";" mark.
@{Fist Name=John; middle name=Joe; Last Name=Boxer} some thing like this.
All cells extracted data is not unique. Means that some cells will not have first name & last Name or Only Fist name like that.
Is it possible to extract using a text and places the values under a table with headers
Column B Column C Column D
First Name Middle Name Last Name
John Joe Boxer
Dec 21 2022 08:07 PM
With Get & Transform aka Power Query:
All Power Query steps with the User Interface