ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
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?
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?
Asked:
Who is Participating?
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
You can use the transpose function in Excel like below:
You copy the column A values and paste special / Transpose in the column B
Something like the attached.
Conversion150204.xlsx
Conversion150204.xlsx
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?
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?
dwcummings
and here is the version without use of any helper columns.
simply dragging the formulas :-)
Book1.xlsx
and here is the version without use of any helper columns.
simply dragging the formulas :-)
Book1.xlsx
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.
All Courses
From novice to tech pro — start learning today.
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