Solved

Converting data in columns to rows

Posted on 2015-01-06
3
83 Views
Last Modified: 2015-01-06
I am trying to convert a column of data (numbers) into a row of data. Is there a function in Excel to do this?
0
Comment
Question by:MalWije
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
Wilder1626 earned 500 total points
ID: 40534655
There is a function called Transpose

have a look here: http://office.microsoft.com/fil-ph/excel-help/switch-transpose-columns-and-rows-HP010224502.aspx


Please let me know if this is working for you.
0
 

Author Closing Comment

by:MalWije
ID: 40534671
Thanks. The solution worked.
0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40534675
i, m happy i was able to help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Download BDel 10 131
Follow Up 12 111
Formatting Index 7 91
mac mini time machine 2 77
There are many Password Managers (PM) out there to choose from. PM's can help with your password habits and routines, but they should not be a crutch you rely on too heavily. I also have an article for company/enterprise PM's.
Note: This is the third blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   We’ve been talki…
The viewer will learn how to edit animations within the presentation, incorporate sound, and set everything up with timing.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now