Data for a given transaction is currently being entered into a table format like the top one. I want to change the way data is entered so that it will show only the Categories and amounts directly associated with a particular transaction in each row this is do to a change in the way the data is entered. I have three years of data I need to convert and doing it manually is a daunting prospect.

I am trying to figure out a way to automate but I always seem to jumble the data. Can someone point me in the right direction.

ReFormat.png

Scott