Restructuring Adress Data

Hello, I would really appreciate your help. I need to restructure some address data for a large data set.
Each person has a unique id.
The phone number in row 3 of patientadresse needs to be removed. The fist row needs to be transformed into its own collumn named street, the 2nd row into a column named city
The name needs to be split into separate columns for first name and name (name is in front, first name after the comma).
See attached images. How can I achieve this for the entire table?
tab2.jpg

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.