Excel Help: Reorganize Financial Statement Data to Easily Analyze with Pivot Tables
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
Cum ut consequatur possimus fuga molestiae et non. Sit quasi cumque autem hic. Officia fugiat est ex provident similique.
Nesciunt sapiente qui adipisci sint quo vel. Reiciendis autem quaerat quas dolorum quia distinctio. Accusantium iste iste beatae neque modi omnis.
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...