Combine Data But Need to Create New Column Name as new current month
Hello Guys,
I am almost done however I can’t achieve the final output I want.
Here’s the raw data I have: Report January, Report February and Report March
Here’s the final output I want: Final Output for 3months ( I only need the ‘Account’ and ‘Amount’ in raw data however need to change the Amount column name into its Last day of the month.
In short, every month it will be added a new data for the current month. So once I have added January, next month, I will add February then March so on until December then repeat to January again for new year.
Hope you can help me guys. Thank you so much as this is really hard for me to figure out.
Note: The account is being added or reduced every month though I still want to retain the old account and only add new account that will be added to preserve everything.