Tom’s Tutorials For Excel: Transpose a Table Range
In three fast, easy steps you can transpose a multi-row and multi-column table to gain a fresh analytical look at your data. The result is similar to an effect with a pivot table, but with the advantage that you can see both views of the data at the same time, side by side.
Be aware that with this manual method the two tables will not be linked. A change to data in one table will not appear in the other table. There are formula and VBA methods to establish such links, but for this example the objective is to transpose a quick snapshot of an entire table range.
Here are the three steps and a view of the final result:
Leave a Reply