I have a spreadsheet which lists data from customer encounters. For each visit, columns are customer name, item 1, item 2, item 3, and item 4.
*The spreadsheet has encounters for more than one customer.
*A customer can have more than one encounter.
*An encounter can have from one to four items, so while the item 1 column always has a value, items 2-4 can either be blank or have a value.
I want to summarize, for each customer, the items listed. I only want to report each item once for that customer.
Example:
John Q Public, pencil, paper, calculator
John Q Public, paper
John Q Public, calculator, eraser
John Q Public, eraser
John Q Public, calculator, paper clip, scissors, notepad
I want to get from that:
John Q Public, pencil, paper, calculator, eraser, paper clip, scissors, notepad
The output can be lumped together in a single cell; I don't need them to go into their own columns.
Is there a way to accomplish this in Excel 2003? Thanks in advance for any assistance.
Bookmarks