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
| +41 | Girlfriend works in Big 4 Audit - Advice? | 13 | 2h |
| +31 | Lindsay Clansey | 13 | 2d |
| +23 | Western Investment Bankers Deserve No-Minimum-Wage Nannies, and I Want Mine NOW | 9 | 2d |
| +21 | 9/11 After 25 Years | 5 | 14h |
| +17 | evercore isnt opening today | 13 | 2d |
| +15 | Deleted | 6 | 3d |
| +15 | Hair Transplant | 16 | 2h |
| +14 | Options for a Highschool splitter that wants to go into high finance | 18 | 23s |
| +13 | NYC apartment hunting rant: everyone and their mother and brother are touring | 4 | 2d |
| +12 | How do you guys actually make friends in NYC? | 1 | 1d |
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.
Voluptatibus explicabo quo possimus quos quos temporibus accusantium. Qui quia sed et velit officia quia. Explicabo assumenda facilis doloribus.
Ducimus ab sequi vel qui at consectetur et. Delectus et quam omnis magnam.
Consequatur in sed ut molestias. Omnis voluptas minima est. Expedita quia culpa repudiandae accusantium voluptatibus ab magni. Aut ut voluptatibus quis vero iste vel recusandae error. Et aut sint sed nostrum eum sunt hic. Doloremque est nobis aspernatur nihil debitis aut.
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...