Flip a spreadshet

plenahan
plenahan used Ask the Experts™
on
I need to flip this spreadsheet so the Window width is where the Window height is and vice versa but, I need the data flipped as well. Any suggestions? VBA code?

thanks

Pat

pat.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I'm not sure if this is what you're looking for. See sheet 2 of attached.

Flyster
pattransposed.xls

Commented:
Are you talking about transposing? Copy the table and use Paste Special with the Transpose option.

Author

Commented:
Flyster I received the new sheet. I'll have to verify the data is correct first. How was this done so quickly? I was thinking vba code.

regards

Pat
Hi Pat,

I copied sheet 1 and then on sheet 2 went paste special-transpose.

Paul
I also forgot to mention, after pasting, I had to change the alignment of some of the cells. In 2003 that's Format - Cells - Alignment tab. Highlight the cell (or rows or columns) and change orientation. In this case it was changed from 90 degrees to zero.

Author

Commented:
Is the procedure the same for Excel 2007? I'm upgrading to that today and won't need 2003 anymore.
thanks.
Yes, transpose is the same. Alignment can be found under the Home tab in Cells - Format.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial