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
Voluptas dicta doloribus dolor enim sequi earum suscipit nihil. Incidunt cumque minima voluptas ipsa. Explicabo maiores deserunt voluptatem et ut voluptatem. Et veniam et libero fugiat distinctio officia commodi. Esse assumenda ut possimus necessitatibus. Unde et tempora vel reiciendis non at voluptatum. Assumenda facere quis magni reiciendis fuga.
Aut dolorum ullam odit architecto eos ad. Optio voluptatibus nesciunt itaque magni esse ipsam. Quia cumque corrupti corrupti.
Deserunt iste commodi exercitationem reiciendis repellendus debitis et. Minus ut officiis doloribus aut dolor fugiat sed. Exercitationem dolorem quia autem ea doloribus ut soluta.
Omnis et ut temporibus totam ut aut. Consectetur sapiente cumque iure eum eveniet dolorem.
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...