You are telling me that the only thing you changed between the 1st and 2nd pciture was the month? There wasn't any other modificaiton? If you change the month back to May will the table go back to the original format?

Also, I don't see what you are talking about regarding the concatenate, the change I notice is that you are getting subtotals where you don't want them. You should explore all the table options and field settings in the meantime.

Also, where is the source data? Are you pulling this from another excel workbook/worksheet?

What values are in the cells for september?