I think this may be a VBA question, but does anyone know of a macro or program to manipulate data to potentially create a flat table with this data? I start with the following:
Customer Name Customer Promotion May- Incurred Liability June - Incurred Liability July - Incurred Liability May - Paid June - Paid July - Paid
Bob Birthday 20 30 40 10 50 30

Unfortunately I want to look at months and compare when the liability was incurred as compared to its payments. So I think I want this instead:
Customer Name Customer Promotion Month Incurred Liability Paid
Bob Birthday May 20 10
Bob Birthday June 30 50

It's thousands of lines of promotions for 10 customers so you could imagine how tedious without a macro. Anyone seen anything like this out there?

Thanks!