How to transpose columns, creating new line based on condition

I have data which is as below:

My data then repeats in this pattern for ~100 rows. Each block of this repetition belongs to the same account and is in the correct order. The name column is the same person's name and is the only consistent value.

I am looking to create a table like this:

I don't need any of the other data.

How would I go about transposing this column to achieve this?

Perhaps there's a way to start a new row based on a cell value (Name), and from there I can delete the unneeded columns?

Thanks