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?
Bookmarks