Tim Henderson of Gannett Suburban Newspapers in White Plans, N.Y., recently posted the following tip on NICAR-L: The way to "flip" data in Excel is this: Select the area you want to flip, copy it onto the clipboard, then choose "Paste Special," and check "transpose" in the resulting dialog. It doesn't work with "cut," only "copy" (at least in Excel 4.0), so you have to paste the transposed data in another worksheet, or another part of the same worksheet and then delete the original selection if you want to get rid of it.
Excel tip: flipping data
Tim Henderson shares a tip for transposing data in Excel by using Copy and Paste Special with the Transpose option, noting that the Cut function does not work for this operation.