have downloaded store list consisting of the following format below.

this is succession of rows, would like to move to columns to eventually run
in MS Word as data for a mail merge.

"Each record" would start with Store.,such that macro would copy Store to
say Col 2, then XYZ at Palm Springs... to Col2+1 and so forth until it reachs
the next line with Store and would go back to Col2
hope this clear
thx

Store
XYZ at Palm Springs Crossing (Store #00690)
482 E Altamonte Dr Ste 1005
Altamonte Springs, FL 32701-4604
Main: (407) 260-9973
Pharmacy: (407) 260-9985