This may seem rudimentary, but how can I go about flipping the income statement so that it reads left to right in excel?
I imported it from the 10k, and the statement reads 2020|2019|2018 etc.
However, I would like it to read the other way as a forecast. Never had this issue before, but is there a shortcut to flip this?
Thanks!
| +233 | Investment Banks Ranked By Your Divorced Blue Collared Uncle | 19 | 15m |
| +157 | Think Twice before Recruiting for HOUSTON IB!! | 65 | 3d |
| +141 | UBS Exits 2026 | 39 | 20h |
| +69 | Congrats on the ROs. I Still Don’t Know Which One You Were | 8 | 1d |
| +41 | Work life balance = highly overrated | 16 | 4m |
| +39 | IB RO Discussion | 8 | 12h |
| +39 | Did not get a return offer due to headcount, but happy to move on. | 8 | 1d |
| +29 | Getting a BB job just for brand name? | 5 | 20h |
| +29 | Lied about bonus to future employer | 17 | 20h |
| +28 | Early VP promo timeline | 15 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
I’m not sure which data provider you downloaded it from, but you can choose to re-format it in the settings before you download it. If not, the simplest solution would just be Ctrl X to move it all around. Not really a big deal
Just pulled it off of the SEC EDGAR widget. Have only every used CapIQ, but Ill try to re-format in the web browser. Thanks
Perferendis repellat porro dolor voluptate ipsam voluptatum. Totam omnis ab officia dicta in magnam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...