How are you getting the data into excel? Power query or a simple copy and paste?
Attched i have done a power query version, using the second plus as a delimiter (couldnt get it to delimit on the line feed, but i am no expert) - this should be able to be refreshed daily when the new data is availible.
the Second sheet is the text to columns version - probably the most simple, just insert a column and text to columns
the third sheet is using formulas. this is possible but when i copied and pasted the data i got a few different formats, i dont know why but it would take a few ifs to get it right.
|