Ask Your Question
1

how do I transpose information in a spreadsheet column to a row?

asked 2018-04-21 19:19:35 +0200

KenJames gravatar image

updated 2018-04-21 20:09:13 +0200

Spreadsheet data all entered in a single column, imported from a document. How do I make that information appear in separate columns on a single row? In other words, how do I transpose a column to a row?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2018-04-21 20:09:39 +0200

David gravatar image

updated 2018-04-21 20:10:26 +0200

  • Select your column of data and copy it;
  • right-click in the cell where you want to start the row;
  • select Paste Special > Paste Special... which should bring up this dialog:

screenshot

  • make sure the [✓] Transpose check box is ticked under Options,
  • click OK.

Your column of data will now be a row.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-21 19:19:35 +0200

Seen: 949 times

Last updated: Apr 21 '18