Format raw text (from Google Forms response) into rows and columns in Google Sheets and append sheet-CodePudding

I have a Google Forms where I'm capturing data in the following format.

Name:Karslten [0023]
Level:1
You managed to complete:
Burpies:30
Squats:45
Bench:29
Crunch:43
TotalLoss: 981

Name:Jaeger [0119]
Level:3
You managed to complete:
Burpies:40
Squats:53
Bench:45
Crunch:53
TotalLoss: 1253
Name:Fostyne [0003]
Level:1
You managed to complete:
Burpies:24
Squats:38
Bench:25
Crunch:32
TotalLoss: 758

I would like to know if it will be possible to use Google Sheets formula to use the data and format it into rows and columns in a specific way. One form entry can contain data for multiple persons.

The format I want to achieve should look like this and all new entries must be appended to the new result sheet.