Text Data to split column

Question

Hi

What function do i need to split the following data. "first entry" is column header "second entry" = column data.

"Asset Number"="A00595753", "Asset Barcode"="BBQ0200", "Description"="Triple Electric Barbeque nr. Parking area", "Quantity of RCD"="1", "Photo Album Link"="https://1drv.ms/a/s!AlpYlQTIANqEhc0xJAzfQi91kgMY1w?e=eOgWRR", "GPS Coordinates "="-27.260908333333333 153.1030888888889", "1. Ex zone or safety observer?"="No", "2. Safety Doc"="Yes", "3. Asset barcode installed"="No", "4. Compliance tag completed"="Yes", "5. Recording of any defects"="No"

Answer 1

Hi Jeovany

Thank you for your help, much appreciated.

Your solution works amazing well. Awesome work.

Cheers

Peter

Answer 2

Hi Peter

Based on your description, sample, and goals I choose Power Query to solve your problem

I also took the liberty to add more samples based on your original one to illustrate the solution

Assuming the headers will remain the same I changed some of the second-entry column data in the INPUTData table

1. You may add or replace the data/values in the INPUTdata table with the real ones.
2. Then Go to the Data ribbon tab and Click REFRESH ALL to update the OUTPUTData Table

You may download here the file with the solution https://we.tl/t-dGM9fbPjj6

Do let me know if you need more help

Regards

Jeovany

Answer 3

Hi,

Cannot understand anything there. Share data in a format that can be pasted in an MS Excel file. Show the expected result clearly.

Answer 4

Try this one

=SUBSTITUTE(TEXTAFTER(TEXTSPLIT(A2,","),"="),"""","")