Hi Brian and @hafizsultan
I appreciate the time you have both taken to help me with my issue.
I have gone back to the excel file and changed the structure of the origianl data to include a year column, so when i pull the file into the query editor is looks like this, now all is missing is the column that displays the date.
Do i add in the code that was sent through to me by Hafiz, or will the code now change because a year column has been added
Thanks guys
Paula