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

βˆ™ 10y 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 do you combine forces acting in different directions?

To combine forces acting in different directions, you can use vector addition. Break each force into its horizontal and vertical components, then sum the horizontal components together and the vertical components together to find the resultant force in each direction. Finally, combine the horizontal and vertical components to find the magnitude and direction of the resultant force.


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.


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

13


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


Find resultant of two vectors one at an angle of 30 degree clockwise to horizontal and other vector 60 degree anticlockwise to horizontal from one point?

To find the resultant of the two vectors, break each vector into its horizontal and vertical components. Then add these components separately to find the total horizontal and vertical components. Finally, use these components to calculate the magnitude and direction of the resultant vector using trigonometry.


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.


How do you do a line break in excel?

Alt + Enter


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.