Creating an Excel macro or formula to transpose and sparse data

Completed Posted Apr 21, 2014 Paid on delivery
Completed Paid on delivery

I'm looking for someone with ADVANCED Excel skills who can create an Excel macro or formula and insert into the attached Excel file.

In addition to sending me the file back with step-by-step instructions to use it.

Take the data in COLUMN A and place it in the columns B through H (see attached Family Practice - PHL - Freelancer [url removed, login to view]):

Provider ID: 5602292 (Excel, column B)

Baiocchi, Gary A., DO (Excel, column C)

Family Practice (Excel, column D)

525 Jamestown Avenue (Excel, column E)

Suite 201 (Excel, column F) Note: This data is not included for every physician; leave blank if not listed.

Philadelphia, PA 19128 (Excel, column G)

(215) 482-2412 (Excel, column H)

I need this done today, please.

Thank you!

Excel Visual Basic

Project ID: #5838572

About the project

5 proposals Remote project Active Apr 21, 2014

Awarded to:

zExcel

Hi, I'll be happy to help you with this project and can start right away Please feel free to message me if you need to discuss any questions you might have

$40 USD in 0 days
(61 Reviews)
6.0

5 freelancers are bidding on average $31 for this job

abdellatif81

Hello Beatitudesoul, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Micro More

$39 USD in 0 days
(6 Reviews)
4.4
k00lcaptchrz

Hi, I have read your project description.. and ready to start work now. i can deliver it today ... Looking forward to hear it from You soon. Kindly send me full file... Refer to pm. thanks Regards Kool

$19 USD in 1 day
(18 Reviews)
3.7
ChrysalisThorne

I am a trained Financial Analyst with an MBA in Finance. I also possess very strong skills in Microsoft Excel which I regularly use to design analytics packages and other solutions within as well as outside of my dire More

$25 USD in 1 day
(0 Reviews)
0.0