How do I transpose rows into columns, and on the 4th row, start a new set of columns?

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

OH MY GOODNESS THAT WORKED PERFECTLY. Thank you so much!!!!

ChemistB,

Would you be able to explain to me what the formula means? I want to try and understand this. How what does the ($G:$G), and then the $A and $1 mean, opposed to $A1? Also, what is the purpose of "-1" and "*4" (which I'm assuming has to do with the four columns I needed to separate my data into.)

Time permitting, would you be able to educate me on the meaning of this formula, please? If not, I completely understand, and still really appreciate your help.

Thank you so much!

Janice