merging rows

  1. A

    Userform with macro to fill manual PO details

    Mr Excel, Pls help me. I am makimg a userform that fills all manual sales bill details into the form. it is working fine all controls are precise. But i overlooked one fact ,one bill can have upto 20 items with different unit price. i dunno how to incorporate these onto the worksheet under one...
  2. S

    Merging rows according to ID and date/time period

    Hey. I'm working with a very large dataset for a campus health center, where the same individuals came in over the course of several years and completed the same 3 surveys each time. I'm using Excel 2010 on Windows 7. Basically I need the three variables' data merged into one row associated...
  3. P

    Consolidating Consecutive Date Rows

    Hi All, I am working with an excel file that shows daily whether an individual is checked into a shelter. The dates are often consecutive. I am trying to merge rows to reflect a true length of stay, not daily. here is what my data looks like: First Last SSN DOB Entry Date Exit Date...

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back
Top