Hey there,

I have a big report (Excel-Format) from which I would like to extract data and consolidate it.
The attached file shows simplified on the left whats there and on the right what I want to have.
(i.e. I only want to copy certain columns and sum all values with the same period and customer)

Example.xlsx

Is there any elegant way to get this done? Doing it manually is not really an option, since the real report will have several thousand lines of data... :-/

Any hints leading me in the right direction would be very welcome.