Stop retyping your table! Change your table layout in a few clicks.
Note: all the screen shots are done using Excel 2010.
From time to time, we receive documents prepared by other people or exported by different systems. If the document is well prepared, good for you; however, there is a good chance that you may get a document like this:
But you really need is this:
What many people do next is what I really admire: retyping the whole table while cursing the document sender or system where the document is exported from! Well, for a small table like the above one it is still ok, what about a big table with a large amount of data?
The good news is, you can do that in Excel in a few clicks, by following the steps below:
It's just that simple. Stop retyping you tables and save the time for real work!