Macro/UDF to auto Transpose cells

Hello and greetings!
I am stuck in a list of my team members more than 2000 where details for every individual is not recorded based on fields/columns but is keprt rows.

For example [sheet 1] contains
Cell reference a1 contains Name1
Cell reference a2 contains department1
Cell reference a3 contains phone1
Cell reference a4 contains email1
Cell reference a5 contains url1


Cell reference c1 contains Name2
Cell reference c2 contains department2
Cell reference c3 contains phone2
Cell reference c4 contains email2

Cell reference a7 contains Name3
Cell reference a8 contains department3
Cell reference a9 contains phone3
Cell reference a10 contains email3
Cell reference a11 contains url3

In output [sheet 2] should contains only three rows:
Cell reference a1 contain Name1, b1 contain department1, c1 contain phone1, d1 contain email1 and e1 contain url1
Cell reference a2 contain Name2, b2 contain department2, c2 contain phone2, d2 contain email2
Cell reference a3 contain Name3, b3 contain department3, c3 contain phone3, d3 contain email3 and e3 contain url3

Note: In this list there is a empty/blank cell between two contact details.

An immediate attention towards this request would be highly appreciated.

Thank you best Regards - AJ