Hello excel magicians,
Can someone please lend me a helping hand with a macro? I am trying to achieve the same result that I would using PowerQuery(Unpivot Columns) and a little bit more.
What I am trying to achieve:
- Unpivot Sheet1 from Column D onward dynamically (there could be more or less than one month added)
- Unpivot Sheet2 from Column D onward dynamically.
- Check if month is already in Sheet2, if not append rows from Sheet1. If there's already data for that month, replace it for those particular matching items and append the rest.
I want to do this without PowerQuery because my table will be ever changing and I don't want to lose the past data referencing that same source.
I have attached an example of what I am dealing with. I would be grateful if someone could help me with some guidance.