I am VBA illiterate, so I will not be able to write a macro or code to concatenate all columns dynamically. I will see if someone from the VBA side can work on this, however in the mean time I suggest that you upload a desensitized version of your actual spreadsheets so that they will have something to go on. To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.