answersLogoWhite

0


Best Answer

You can transpose data. Select the cells in a column. Do a copy. Move to where you want the data to go to. Then do a Paste Special and pick Transpose. The orientation of the data will be changed so that it is now in a row rather than a column.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you break particular data of vertical to horizontal in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When should you break the vertical axis of a bar graph?

When the horizontal variable goes from positive to negative.


How would you explain how to find sine and cosine within each quadrant of a unit circle?

To find the sin/cos at a given point on the unit circle, draw a radius to that point. Then break the radius into components - one completely horizontal and one completely vertical. The sine is the vertical component, the cosine is the horizontal component.


What is a cumulative frequency histogram?

-Construct a frequency table-Draw a horizontal axis and mark off the intervals.Label the horizontal axis.If the first interval does not start at 0, use a "break" symbol on the axis.-Draw a vertical axis and identify a scale for the frequencies. Label the vertical axis.Often, the vertical axis is "frequency".-Draw bars with heights corresponding to the frequency values in the table.-Give the graph an appropriate title.


How do you explain the Tags BR and HR?

br is a line break, hr is a horizontal rule.br adds vertical spacing between elements on a page, much like the spacing between to paragraphs of text.hr adds a horizontal line. example:before hrafter hr


A player kicks a soccer ball from ground level and sends it flying at an angle of 30 degrees?

13


What are the types of line in visual arts?

Horizontal, vertical, diagonal, curved, patterned, contour, implied, actual?


Which way are tennis strings generally supposed to break vertical or horizontal?

Strings aren't "supposed" to break. They break due to friction caused by repeated rubbing back and forth across each other. When impacted with the ball, the path of the swing causes the mains (verical strings) to shift their position on the crosses (horizontal strings). This "sawing" motion generally results in breaking the mains before the crosses.


The vertical division in a spreadsheet?

They are called rows and rows are numbered.


Is the vertical stand for ps2 good does it break?

well the vertical stand looks cool. but if it tips over.your ps2 has a good chance to break.


How do you do a line break in excel?

Alt + Enter


In which direction is compact bone most susceptible to force?

Compact bones can withstand huge amounts of vertical force. When compact is exposed to horizontal force it can break easily. Compact bone however is very intriguing and resilient in its function.


What is column break in Microsoft Excel?

A column break is a term associated with Microsoft Word, not Excel. In Word, it starts a new column of text. In Excel, you can just go to another column to start entering new data.