|I'll assume you actually have a blank row between each block of data.|
I'll also assume that each name, address and city/state is in it's own cell in Column A, starting in A1.
In B1, next to Fred Wuffin, enter this formula in a cell:
=INDIRECT("A" & ROW())
In C1 enter:
=INDIRECT("A" & ROW() +1)
In D1 enter:
=INDIRECT("A" & ROW() +2)
You should now have all of Fred's data next to each in B1:D1.
Now highlight those 3 cells as well as the same 3 cells in the next 3 rows. In others words B1:D4.
Grab the Autofill handle and drag down to the bottom of your data.
You should now have your transposed data, separated by 3 blank lines each.
Do an Edit...Copy...Edit ...Paste Special...Values to get rid of the formulae and turn the data back into text.
Sort as desired to collapse the data.