Excel Tips:
You would use this feature if you want to transpose data to get a better display; however, retyping all data would be the last thing you would need to do if you know how to use the Transpose function in Paste. Here’s how: copy the area you want to transpose, move the pointer to another blank location. Go to Home->Paste Special (Paste Options) ->Transpose, please note that this function won’t activate until you copy the data first.