Forum Discussion
INDEX Confusion: Return related data from multiple columns
Greetings community, I am having an issue with a exported file I am trying to manipulate into returning specific data based on the location of the matching reference. Situation...my company...
Hi Eddie,
You may be able to address the issue by using Power Query to "Unpivot" the monthly sales Table and then do your reporting / analysis via a Pivot Table?
If you can share your file or a sanitised version then that would help
Thanks