Help with Access Query! - Merging Rows with Unique ID

[adamg_]

I am having a hard time either using Excel or Access (2007, xp) to merge rows. Our e-commerce site splits an individuals cart into multiple rows in a .csv file. See attached file as an example.

I would like to:
- Merge rows by Name or Email
- For each "Lineitem name" per Name/Email, have the name and quantity in the same row
- For each Name/Email have the total

Example:
email 1 has 4 entries, they selected:
- Select your item - item 3
- Select your addon - item 7


- Select your addon - item 8
- Select your addon - item 2

I want to see all of this data in one row along with quantity and ultimately either price or total.

I assume I can create a complex index/match function in excel or create a table to reference for Access. Having trouble figuring this one out! HELP!

See attached.

[June7]

Displaying related records horizontally (left to right) is tricky. Review
http://forums.aspfree.com/microsoft-...ry-322123.html
http://allenbrowne.com/func-concat.html