Combine multiple columns within multiple rows based on value of a column up until change i

Referring to the attached image with sample data, I would like to combine date, person, and note from multiple rows into 1 row with line breaks for each set of combined values. Each note takes up a row with Name and ID blank, so every row under the main row with values will need to be combined. See attached image for data, and desired output.

Each ID is unique, and all rows below that are date, person, and note aligned. Some users will not have any notes. All notes are enclosed in paragraph tag, and that needs to be removed as well.

Thank you!

EDIT: Used the following M code in Power Query

HTML Code: 

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Perhaps someone will be able to put all of this into the power query code.
The code listed in post #1 was appended to read:

Please Login or Register  to view this content.

The resulting table (top of Table3 sheet) is used as an intermediate step
The Name:Person columns are copied using the formula: =IF(A1="","",A1)
The Notes column (not the header) is transposed using: =SUBSTITUTE(SUBSTITUTE(E2,"<p>",""),"</p>",CHAR(13))
Let us know if you have any questions.