I have the data file as below:
I want the output as below (the header must the in sequence from Jan-Dec, those blank will show 0 value)
Hi @ATC
AN alternative would be to create the headers you want in the correct sequence, then Union that with your dataset.
Hi @ATC ,
would you have some sample data with what you have at the beginning of your workflow?
Arthur
Hi @ATC,
Hope it helps.
If this was helpful for your please mark as solved.
Thanks!
Thanks a lot, it works!