Thread: Moving data from column A to Columns B,C,D,E
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael P. Michael P. is offline
external usenet poster
  
Posts: 1
Default Moving data from column A to Columns B,C,D,E
My data looks like this:

A. Rafanelli Winery
tel. +1 707.433.1385
4685 W. Dry Creek Road
Healdsburg, CA 95448

I want it to look like this:
A. Rafanelli Winery tel. +1 707.433.1385 4685 W. Dry Creek Road
Healdsburg, CA 95448
The data set is every four rows with a blank row inbetween is there a macro
out there for this other than copyPastespecialtranspose... A million times
over
Reply With QuoteReply With Quote