Need to consolidate multiple rows into one row for import to access (no VBA please)

I pull data from an application into multiple .csv files. A couple of these pulls, based on the fields selected (Follow-up by and Description) cause the rows for one event to multiply (attachment). I need to consolidate all the rows for the same event into one row. The attached has a formula I used recently that worked for another sheet but what I was worried about is that the formula I use to "count" the # of times an event is present and the reference column in my vlookup is now making my results capture events that are not appropriate.
So in the attached you will see for example File ID 6 captures the correct follow up comments and description (color coded yellow) but File ID 61 overlaps (color coded blue).
What I ultimately need is for the description to be tagged to the person who made the comment and if there is a second or third or fourth etc for those to be tagged to the individual. Then ultimately pulled together in one column at the far end, combining all of them so when I pull it all into access they appear in the same cell. The largest count of one event I've found to date is 14 so that is why I have up to 14 across row1.
what i left out in col U would be the if then stmt that would look for a value in each column and if something exists put it there and separate it with a colon, then my import sheet would use a vlookup and of course the first one it finds would be all I need for the import.
Hope this makes sense.

Unfortunately i'm going to be away for the next couple hours so I cannot respond to any questions or solutions. Thanks all.

Nobody able to help me?

E2:En

Please Login or Register  to view this content.

G2, et al.:

Please Login or Register  to view this content.

Hi, Try with the below array formula in G2 and drag it down across, check it out the attachment

Formula:

Please Login or Register  to view this content.

Sorry for being away so long but just now getting back to examine this.
I'm giving both of you a big thanks for making the attempt.
protonLeah, it looks like yours is so close! I'm getting value errors once the event number goes above 99.
there will be between 2 and 4 thousand of these every month. The numbers will continually increase as each event gets assigned its own event number - only used for one event.
boopathiraja, I think yours may work, but it appears to be a memory hog.
I've attached add'l info to show how they get close but not quite there.
for example, col U in sheets 2&3 show how i try to pull it all together so when i import it into access all the comments occupy only one cell and the event is only on one row.
Sheet2 is using protonLeah's formulas.
Sheet3 is using Boopathiraja's array formula.

Try with the below array formula

Formula:

Please Login or Register  to view this content.

I changed the red text in the formula of ProtonLeah

E2

Please Login or Register  to view this content.

boopathiraja, yours does it all in one (big ugly) formula. pretty cool, that way i don't need the, up to 15 or more add'l columns.

Oeldere, your change only works after the event number goes above 2 digits, so the rec would be use first for 0 to 99, then adjust the 2 to a 3 for 100 to 999, then 3 to 4 for 1000 to 9999, etc?

I'm giving you all a rep for helping. Thanks and i think i have the solution by Boopathiraja.

Please Login or Register  to view this content.

See the attached file.

I think it also works for the other values.

Please reply.