Consolidating data that varies down rows

I'm in the process of trying to build a contact database to import into a CRM, and the best way we can figure to do this since our contacts weren't kept in any manner is to export using our online product delivery system. Essentially what that spits out is a list of email address, names, customer name, their document (product) and the quantity they purchased it.

When I query and export this data from our delivery system, for each document (product) the customer purchased, it basically duplicates the customer data down into new rows. What I would like to do is find a way to pull all the document (product) information onto the same line so I can import and use the product as a tag. The downside is that there isn't consistency in how many rows the data spans per customer. So, for example you might have one customer that only purchased one product, and thus only takes up one row. Then you have a customer who purchased 1 product multiple times, or multiple products. That customers information takes up 2+ rows. The only consistency is that the line that ends the individual customer information has the email address and "total" beside it.

Is there a macro or way I could create a macro to essentially look at the email address, and for each email address that matches, move the next line of data up so that all data with the same email address is on one row, rather than down columns.

I've attached a mock data sheet to show you essentially what my data looks like if that is helpful.

Hi, thanks for the response. I've attached an example 2 to show what I could image that looking like. My ultimate goal, what I'd like to end up with is all customer data on one row. So, instead of having 5 rows of customer purchase data have it all on one row, just spread out across columns. Does that make sense? I'm trying to find a way that I can combine all of the products a customer has purchased into one cell so that I can use that as tags.

Hi dflak, thanks for the response. Not really, I'd like to get all of that document (product) information into the same field in the end, on the same line as the customer. So, rather than a customer having 5 rows of data if they bought 5 products, have one row per customer with all the document (product) information in one field.

YES! That is exactly what I would want. Two quick changes: Can it bring back the first name field, last name field (rather than full name), and email address? Also, to deploy this will I just grab the macro and run it in my actual document? THANK YOU!