Customer Payment Methods

[bsd221]

I have a list of customer numbers and how they paid over a 5 month period(more than 20,000 rows), either check or credit card. I want to be able to identify which customers paid with Check, which customers paid with credit card and which customers paid using both credit card and check.

I have pivoted the data but I cannot find a way to break these out into the buckets I need.

[JohnTopley]

Attach a sample workbook (not image).so that we do not have to manually key in your data to do any testing.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.