Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
MS Excel Convert Multiple Rows to Columns
Posted on 2015-02-04
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
2-
2
- +1
8 Comments
Active 7 days ago
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
Active 2 days ago
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
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
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?
Active 2 days ago
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
Featured Post
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Learn how Concerto can help you.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month5 days, 4 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.