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.
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.