Problem: I have product “A” monthly sales table where
I need to switch table orientation from portrait to landscape (or vice versa).
|
Month
|
Monthly Sales
|
|
Jan
|
520,514
|
|
Feb
|
361,696
|
|
Mar
|
579,615
|
|
Apr
|
542,257
|
|
May
|
412,810
|
|
Jun
|
359,068
|
|
Jul
|
440,980
|
|
Aug
|
457,383
|
|
Sep
|
511,888
|
|
Oct
|
525,656
|
|
Nov
|
581,972
|
|
Dec
|
452,541
|
Solution: You need to transpose the table. You can do
so by copying the table, then selecting Paste Special > Transpose as in the following
illustration:
|
Month
|
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
Monthly Sales
|
520,514
|
361,696
|
579,615
|
542,257
|
412,810
|
359,068
|
440,980
|
457,383
|
511,888
|
525,656
|
581,972
|
452,541
|
No comments:
Post a Comment