Transpose Data in every 2nd row (sorta) to column on right [easy if you know how to code]

[lougs7]

Hello All,

Please open my Spreadsheet so you know what I am talking about As simple as the task is it may seem complicated if you do not open the spreadsheet first

I have a list of Medical Clinics in Quebec, Canada that I need cleaned up but can't figure out a code for this. It is pretty simple if you are proficient with VBA Right now the list contains Clinic name in column A and the associated address shows in the row underneath it, the next row after the address is now a new clinic name and like the previous the address is underneath it, and so on. I would simply like to transpose the address for each Clinic Name and place it in column B and alligning it, at the same time have the region headers like I have already there (view Sheet 1). The problem why I can't do it is because eventually the list breaks as we move on to another region.

The Sheet titled "Sheet2" is where the Data is. The sheet titled "Sheet 1" is my vision of what I would like to do.

Does anyone know a code that won't break at the region changes and paste all the data aligned on the next sheet like I have done manually?

I appreciate your help tremendously!

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

It assumes the addresses start with a number. It misses those that don't.