I put is in VB Editior, and it gives me an error in the line (xlUp). Please
advise, I appreciated it.

"Max" wrote:

I need help, I have an excel file that has Prov. Nums, Addresses,
and specialties, in multi-rows. I need to move the Addresses and Specialty
rows to be columns reflecting the Prov. Num.
For example:

Provider Num Address Specialty
125126 360 95th Internaml Medicine
125126 320 85th Cardiology

Change to:

Provider Num Address1 Specialty1 Address2 Specialty2
125126 360 95th Internaml Medicine 320 85th Cardiology