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)
Solved! Go to Solution.
Hi @ATC ,
would you have some sample data with what you have at the beginning of your workflow?
Arthur
Hi @ATC
AN alternative would be to create the headers you want in the correct sequence, then Union that with your dataset.
Thanks a lot, it works!