Rows to Columns
Are the data sets consistent as in 6 cells per set?
If so, enter this in G1 and copy across to L1.
=INDEX($A:$A,(ROWS($1:1)-1)*6+COLUMNS($A:B)-1)
Select G1:L1 and copy down until you get zeros showing up.
Paste SpecialValuesOKEsc then delete column A
If you want a macro post back.
Gord Dibben MS Excel MVP
On Mon, 10 Mar 2008 11:28:03 -0700, reno wrote:
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
|