Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Converting data in columns to rows

Posted on 2015-01-06
3
Medium Priority
?
106 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 2000 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

It’s a season to be thankful, and we’re thankful for users like you who engage on site, solve technology problems, and network with others in the industry. What tech are we most thankful for? Keep reading.
Transferring FSMO roles is done when an admin wants to split roles between certain Domain Controllers or the Domain Controller holding the Roles has been forcefully demoted using dcpromo / forceremoval
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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 …
Suggested Courses

972 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