I am trying to GroupBy (Sum) column “Quantity” in “Column4” based on “Column1”, “Column2”, “Column3” only if the string of column “Date” matches “Column4”'s header (in my case a date e.g., = “2019-01-01” and “2019-02-01”). I have 72 “Column4”-type columns in total (i.e., every month from “2019-01-01” until “2024-12-01”). Is there any recommendation on how to best do this?
For an example please look at the attached picture below:
Many thanks in advance for your support - highly appreciated.
I think you need the
The group columns will be Column1/Column2/Column3, and the Pivot columns will be Date. Then you need to sort out your aggregation method, which looks like Sum of quantity. There is also a blog post which probably explains more clearly:
Many thanks for your quick help - highly appreciated. Your proposed solution works perfectly.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.