Columns to Rows based on email address

I am so very stuck.

I have a list of 100s if not 1000s of file upload instances in a spreadsheet. Each Time an upload is made it is noted as text information in a column (to corresponding folder). Each email address uploads up to 12 files. I want to join the separate each with a single upload, to be one row with all 12 (or however many they have done)

WORST explanation ever... I know. I've had zero luck finding any help.

I've attached a workbook. The top is a small example of what i have and the bottom is what i am trying to get to though use of a VBA i think?

Thanks in advance folks!!

H

Welcome to the forum.

I did it in row 42 down.

This array formula in A42 (confirm with Ctrl+Shift+Enter) and copy down to return unique values:

Formula:

Please Login or Register  to view this content.

And this formula in B42, copied across and down:

Formula:

Please Login or Register  to view this content.

Good luck!