PowerQuery - Excel

[Bennets04]

Hey all,

So getting some data from my inbox but need help with getting it in the right format in PowerQuery....

Here is a sample of what the data comes in like (Body of the email) - the format can change sometimes so its making it difficult to know where to start. Ideally I need the data in rows by the date mentioned...... Anyone want a challenge????

 

[jdellasala]

That's a screenshot, not data. Post the data using XL2BB.

 

[GraH]

Split column by delimiter linefeed. Split into rows. Split column on first space.
All can be done through the UI.

 

[Bennets04]

Split column by delimiter linefeed. Split into rows. Split column on first space.
All can be done through the UI.

This worked a treat!!!!!!

 

[GraH]

Thanks for the feedback, you can consider to mark my post as solution. It helps others.