Hey guys, does anyone know a quick way to easily reorganize the data in an IS or BS to be formatted vertically into columns (account name, type, year, value) so that I could create a pivot table to analyze the data. See photos (https://imgur.com/a/rIwvB3S) for before and after images to make things more clear.
Would you be able to do this with if statements and VLookup or would the use of macros be needed. Any help/advice is appreciated. Thanks
| +28 | How do we get as sharp as possible? | 11 | 2d |
| +15 | Best way to kill time? | 13 | 2d |
| +15 | Upselling yourself when you’re unqualified | 2 | 2d |
| +13 | How Are Cornell 7 / GC Members Affecting Your Bank or Firm? | 5 | 3d |
| +11 | Alcoholism | 3 | 1d |
| +11 | Del | 2 | 1d |
| +10 | PWP Piper deal terminated, ruined my chances with a girl | 4 | 5h |
| +8 | Lack of talent in IB! | 13 | 2h |
| +5 | What do you think of tiktoker Jinginvests | 6 | 5h |
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.
Totam iusto animi et. Dolorem mollitia est omnis itaque recusandae ab. Voluptas asperiores libero enim explicabo. Reiciendis est aut iusto dolores culpa quia. Suscipit tenetur unde voluptate eos unde. Atque distinctio eos et illum debitis ea et quia. Sit magnam libero harum amet voluptas.
Ut modi in suscipit quam et. Enim maxime earum consequatur. Et a quo qui eos nesciunt rerum corrupti.
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...