Hello. Can someone please help me.
I have been struggling with this for days! In the screenshot you will see sales statistics of several products (A:D) from different branches (E) in specific years (F). In the end the goal is to get the sales statistics per month (G:AD) in one row (see the red squares). Then duplicated rows of a products will be deleted so that i have one unique row per product per store with sale statistics for May 2018 to April 2019.
The problem is shifting sales to one row takes a lot of time (14500 rows!) by hand.
I tried conditional formatting and formulas but I am stuck.
Some products have sold in every year (2017,2018,2019 blue highlight), some in two years (2017,2018 or 2018,2019, etc.green highlight) and some only in one of the years (yellow highlight).
Any ideas on solving this problem? It would be really appreciated!
Regards
Bitter
Problem-01.jpg
Bookmarks