asked on

MS Excel Convert Multiple Rows to Columns

I have data in the following format in an Excel spreadsheet.

Customer Name DDS
1 Sleepy Hollow Dr
Carmel Valley CA 93924
Add phone number
calbookslr@aol.com
Planning for your Onsite Evaluation

Customer Name DDS
VA Palo Alto Health Care
3801 Miranda Ave
Palo Alto CA 94304
650-493-5000
Oral Conscious Sedation

Customer Name
877 W Fremont Ave Ste E-1
Sunnyvale CA 94087
408-736-4332
admin@siliconvalleyoms.com
Office Anesthesia Emergencies

Is there a method in which each row in these data sets can be converted into a column?

Wilder1626

Hi

You can use the transpose function in Excel like below:

You copy the column A values and paste special / Transpose in the column B

Phillip Burton

Something like the attached.
Conversion150204.xlsx

ASKER CERTIFIED SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Douglas Cummings

ASKER

Thanks for responding.

I have literally hundreds of records that need to be converted into columnar data and it seems to me that both suggested methods require work - either record by record or annotation of each record. Am I missing something?

Phillip Burton

You are missing something. My solution is entirely formulaic, so you copy them down.

Douglas Cummings

ASKER

Perfect. Thanks, I appreciate the help.

Phillip Burton

Professor J

dwcummings

and here is the version without use of any helper columns.

simply dragging the formulas :-)
Book1.xlsx