I wish I could have someone here in person because I don't know if this question will make sense in writing, but how do I transpose rows into columns, and on the 4th row down, start a new set of columns to transpose?

For example, I have a veryyyyy long list that looks like this:

Column 1
Name 1
Address 1a
Address 1b
Type 1
Name 2
Address 2a
Address 2b
Type 2
Name 3
Address 3a
Address 3b
Type 3
Name 4
Address 4a
Address 4b
Type 4
Name 5
Address 5a
Address 5b
Type 5


I want to transform it to look like this:

Column1 Column 2 Column 3 Column 4
Name 1 Address 1a Address 1b Type 1
Name 2 Address 2a Address 2b Type 2
Name 3 Address 3a Address 3b Type 3
Name 4 Address 4a Address 4b Type 4
Name 5 Address 5a Address 5b Type 5

I know this is a long shot, but is there anyone out there who knows if there's even a formula to sort my data this way? Thank you!

Best,
Janice