4

I have a table in a Google Document. How can I convert rows into columns, i.e. transpose the table?

Example:

enter image description here

| improve this question | |
5

I would use the transpose command of Sheets for this.

  1. Copy-paste the table into spreadsheet, e.g., into the range A1:E7
  2. Elsewhere on that sheet, enter =transpose(A1:E7)
  3. Copy-paste the output back into the document, which will recognize it as a table.

I tested this with a table similar to yours, containing linebreaks in some cells. The only thing lost in the process was the text alignment: the output of transpose command always has the default alignment (right-aligned numbers, left-aligned text). But this is not hard to fix manually.

| improve this answer | |
  • 2
    This answer should be accepted by now – Ted Jul 12 '17 at 11:28
  • 1
    the table in the question is however a Google Document, not a sheet – Jay Wick May 28 '18 at 2:09
  • Yes I also need the answer for Docs but OP probably should've been more clear, since Google's poor product organization means Sheets is a part of the Docs suite of products (Docs includes Docs and Sheets, etc.)... – Hack-R Nov 24 '18 at 17:38
1
  1. Copy-paste the table into spreadsheet
  2. Copy table from spreadsheet
  3. In spreadsheet Edit > Paste special > Paste transposed
  4. Copy-paste table back
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.