answersLogoWhite

0

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

Still curious? Ask our experts.

Chat with our AI personalities

BlakeBlake
As your older brother, I've been where you are—maybe not exactly, but close enough.
Chat with Blake
EzraEzra
Faith is not about having all the answers, but learning to ask the right questions.
Chat with Ezra
BeauBeau
You're doing better than you think!
Chat with Beau

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