Am new to Excel forum... so a big hello to everyone.

I need help transposing data from multiple rows to multiple columns.
The data i have, looks like this


ABC Company
John Doe
Anytown
(000)000-0000

wwwww
eeeee
rrrrr
ttt
yyy
uuu

ww
eee
fff
ggg
hhh

asds
vxcvx
sefs

aaaa
gggg
hhh
uuuuu
oooo
ppppp


Is there a formula or macro i can use for the data to look like this

ABC Company ABC Company John Doe Anytown (000)000-0000 #N/A #N/A #N/A
John Doe
Anytown
(000)000-0000

wwwww wwwww eeeee rrrrr ttt yyy uuu #N/A
eeeee
rrrrr
ttt
yyy
uuu

ww ww eee fff ggg hhh #N/A #N/A
eee
fff
ggg
hhh

asds asds vxcvx sefs #N/A #N/A #N/A #N/A
vxcvx
sefs

aaaa aaaa gggg hhh uuuuu oooo ppppp #N/A
gggg
hhh
uuuuu
oooo
ppppp


I can use transpose but this file consists of 70,000 companies, names and addresses, so doing this manually seems impossible.

Any ideas?