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 [...]
Tag archives for paste special
Eliminate Trailing Spaces with the TRIM Function
Column A and column B appear to be identical, but they aren’t. If we did a VLOOKUP function with the contents of column A as the lookup value, and the contents of column B in the table array, we wouldn’t get a single match. Why? Because column A has spaces after the last letter of [...]
category: Excel
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.
