I get exports from an event registration form, where each order(row) contains order date, purchase price, and info for between 1-4 registrants. Each registrant has columns for first name, last name, and date of birth. What I need is to split up these rows such that each individual person is on their own row, with first, last, and DOB on the row, ideally along with the other order information duplicated too.

This may be confusing so I have mockup date for the form I get exports in, and the form I'd like to convert them to.

What I get:
<https://drive.google.com/file/d/1xt64Re2CTlbQnHuRy1dQaFeNV5OmETfW/view?usp=sharing>

What I want:
<https://drive.google.com/file/d/156WmiQ4Tx4JGB5FYLTqHBuVmJqi20pRZ/view?usp=sharing>

[I found this tutorial](https://www.techrepublic.com/article/a-super-easy-way-to-generate-new-records-from-multi-value-columns-using-excels-power-query/) which seem very close to what I want using Excel Power Query, but it is describing a method for when the multiple items are in one column separated by comma. My situation is a bit different and I can't make it work.

Any ideas?