I have a table in a Google Document. How can I convert rows into columns, i.e. transpose the table?
Example:
4
asked Dec 20 '15 at 0:59
5
I would use the transpose command of Sheets for this.
- Copy-paste the table into spreadsheet, e.g., into the range A1:E7
- Elsewhere on that sheet, enter
=transpose(A1:E7) - 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.
-
2
-
1
-
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
