I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined. I may also have rows of customer data that are not in need of combining. A unique customer member number can be used to identify the rows...
I have a dataset with all the events which have occurred under their unique ID.
I have already retrieved data to confirm that an event occurs in 1/1/2011-06/30/2011 and another event occurs between 1/1/2012-6/30/2012. Sometimes multiple events occurred in each date range.
I need to combine...
The title might be confusing but I have an example below to show what I want to do. In the image below ("pre-combine rows" image) I show a table of values which was generated by a multi-step process.
The steps in generating it are not really relevant to this problem, but for the curious, I...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.