Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

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?
0
dwcummings
Asked:
dwcummings
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Wilder1626Commented:
Hi

You can use the transpose function in Excel like below:
Tranpose
You copy the column A values and paste special / Transpose in the column B
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Something like the attached.
Conversion150204.xlsx
0
 
ProfessorJimJamCommented:
my version is a much easier solution.

check attached.

also if you want to learn it and do it by yourself here is video

https://www.youtube.com/watch?v=MpEk5Qrfce8
Book1.xlsx
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
dwcummingsAuthor Commented:
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?
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
You are missing something. My solution is entirely formulaic, so you copy them down.
0
 
dwcummingsAuthor Commented:
Perfect. Thanks, I appreciate the help.
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
?
0
 
ProfessorJimJamCommented:
dwcummings

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

simply dragging the formulas :-)
Book1.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now