Transposing Excel data means flipping your rows to columns and columns to rows. In the example above, I want my transposed data to update if I change one of the numbers in my original data. Transposing through pasting options, like in last week’s post, is not a good solution here, because my transposed data would not change if [...]
Tag archives for Transpose
Flip Your Rows to Columns and Columns to Rows
Sometimes you want your rows to be columns and columns to be rows. But copying and pasting your data into this new format by hand is time consuming and full of opportunities for mistakes. Excel gives you two options for flipping rows to columns, aka transposing your data. This week we’ll cover the first. Paste [...]
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
