Google Docs – How to Transpose a Table

google docs

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

Best Answer

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.

Related Topic