combine data in rows

  1. L

    Bring three rows to one row remove duplicates

    This seems simple but can't figure it out. Thank you for helping! Need a excel 2007 formula (not macro/vba) to bring three rows containing data into one row. ie As this sheet shows, all three rows 1,2,3 are brought into Row 5 and then duplicates are removed.
  2. D

    VBA code to merge rows

    Hello, I am trying to merge cells in rows based on the value of the cell in Column A of my spreadsheet (containing Document Type) through the continuous rows containing no Document Type in Column A [see below BEFORE and AFTER examples below]. This needs to loop through the entire spreadsheet...
  3. J

    Combining Multiple Fields Into 1 Final Address File

    I am trying to create a new sheet combining various address fields from another sheet to make a master package list. If anyone could please perhaps help me get started, I would be beyond appreciative :-) My workbook has 2 sheets PM_Client Sample and PM_Client Sample_2. So far anything I have...
  4. R

    How can I delete every 3rd row/add 'by'/combine ever two rows (besides doing it manually)

    Hi, I have data that has this format: <Book Title> <Author> <Purchase Date> (repeat...) Here's a sample (the first 2 sets where the above format is a set): The Wrong Side of Goodbye Michael Connelly November 22, 2016 The Jewel of Dantenos Brian D. Anderson November 16, 2016 It's a long...

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
Back
Top