How about a column in data that is Month # and Month Abr concatenated for sorting purposes
01 - Jan, 02 - Feb etc
Then use a Pivot and use that concatenated column as column on the Pivot
I am not much clear on the suggested approach, request you to please explain a bit more on the same.
well you wanted the columns to be added dynamically. the easiest way would be to use a Pivot since the columns are based on the values in the data. and if the values of that column are Month Name/Abbreviation for that date then you will get month columns.
Have you worked with Pivots before?