Transpose table in Word

Question

Is there a way to transpose (swap rows and columns) in post-ribbon Microsoft Word (currently using 2013)?

For example, in this table, I want the top headings to go on the left (én, te, etc), and the left headings (van, megy, jön) go to the top (obviously with the data moved also) table to be transposed

I currenly copy and paste into Excel, copy and paste again but choose the special paste option : Transpose, then copy back to word. But is there a proper way to do this natively?

transpose menu

score 1 · Answer 1 · edited Oct 28 '17 at 16:58

Try this macro:

Sub transpose01()
'
' transpose01 Macro
'
'
' to transpose rows and columns in a table
Dim NumCols As Long, NumRows As Long, RowCounter As Long, ColCounter As Long
Dim CellText As String
NumCols = ActiveDocument.Tables(1).Columns.Count
NumRows = ActiveDocument.Tables(1).Rows.Count
ActiveDocument.Tables.Add Range:=Selection.Range, NumRows:=NumCols, NumColumns:=NumRows
RowCounter = 0
While RowCounter < NumRows
ColCounter = 0
While ColCounter < NumCols
CellText = ActiveDocument.Tables(1).Cell(RowCounter + 1, ColCounter + 1).Range.Text
CellText = Left(CellText, Len(CellText) - 2)
ActiveDocument.Tables(2).Cell(ColCounter + 1, RowCounter + 1).Range.InsertBefore CellText
ColCounter = ColCounter + 1
Wend
RowCounter = RowCounter + 1
Wend '

End Sub

Welcome to Super User. Can you also provide a short, plain-English explanation of what this macro does (or add appropriate comments in-line with the code)? — I say Reinstate Monica, Oct 28 '17 at 15:33

score 1 · Accepted Answer · answered May 07 '13 at 17:45

1

I think using Excel is the only way.

answered May 07 '13 at 17:45

András

486
3
8
31

1

and to correct the content: mi VAGYUNK, not VANJUNK – András May 07 '13 at 17:46
:/ I guess people don't use this option that much. lol thanks for helping out my hungarian though! – Jay Wick May 07 '13 at 18:04
1

People should never use it, as it is completly wrong :) Higgy nekem, elég gyakran használom ;) – András May 07 '13 at 19:19
3

Even Microsoft [suggest to use Excel](http://support.microsoft.com/kb/143321) for this task. – Adam May 08 '13 at 04:26

score 0 · Answer 3 · answered Mar 11 '18 at 22:11

0

Any experience with this: https://www.extendoffice.com/documents/word/1413-word-transpose-rows-and-columns-table.html there maybe a fee after free trial?

answered Mar 11 '18 at 22:11

tigr

109
1
2

Transpose table in Word

3 Answers3