combine rows

  1. D

    VBA Code for combine duplicate row and keep columns into same rows

    Hi, I've a report in Long format and some of the value in column A are duplicate. Is there any VBA code to combine duplicate value but at the same time transform my data into wide format? This is the report that I've. Each Employee ID in column A might have duplicate row depends on how many...
  2. K

    Combine multiple rows into a single row

    Here is a sample table of the data we need to combine into single rows of data based on the office. Measure 1 Measure 2 Measure 3 Measure 4 Measure 5 Measure 6 Measure 7 Measure 8 Measure 9 Office 1 8950 8950 8950 Office 1 3732 3732 3732 Office 1 8045...
  3. G

    Combining rows from multiple workbooks to one workbook

    Hello everyone, I'm newbie at VBA but still learning :) I need a macro that combines every row from a worksheet to another one. Sample Files: https://www.dropbox.com/sh/17ukkp4dgnudle7/AAAF7GUewNXekZdkVvHh2xVFa?dl=0 In this files, you see 4 sample files and 1 combined file.. every file...
  4. A

    VBA - How to complete one loop before beginning another

    I have a code that searches Sheet1 ("Location") for certain criteria and populates Sheet2 ("Supply Usage Form") with that data. This works fine, after looping through all the rows on Sheet1, I need the code to loop through all the newly added data in Sheet2 for duplicates, combine the rows and...
  5. J

    Combine Data From Two Rows Into One Row

    I'm not really sure what the correct name is for what I want to do, so here's a description. I have an Excel sheet where column A has, in some cases, the same value, but column B is always different. I want to move the secondary column B values to column C, Column D, etc. so the values are all...
  6. S

    Multiple Duplicate Rows to Single unique Row (Combine multiple duplicate rows to one)

    Hi, I have a sheet with the data like below, can some one help me with a formula or something else to get the expected output? In my sheet i have a row with the same data multiple times, i need only one row with the same data and wanted to eliminate all duplicate rows and need same rule for...
  7. C

    VBA / Macros for combining multiple cell ranges based on adjacent cell values

    I've a range of text with details such as Name, Email ID, Telephone and Address. I want the all the address lines to be combined into once cell separated by line breaks as given below I've been using "kutools for excel" combine rows option for these kind of functionality and it is okay...
  8. C

    Combine Multiple Cell Ranges based on adjacent Cell Values

    I've a range of text with details such as Name, Email ID, Telephone and Address. I want the all the address lines to be combined into once cell separated by line breaks as given below I've been using "kutools for excel" combine rows option for these kind of functionality and it is okay...
  9. O

    Combining every N rows into one row macro

    Good Morning all, I've been newly hired right out of school as a data reporting specialist at KSU. A part of my job is tracking donor data for our non-profit community engagement courses. These are free courses we offer to the community to help teach work skills like IT, reading, and writing...
  10. M

    Combining rows that meet a criteria

    Morning! I am wanting to combine rows into a single cell if they meet a certain criteria. I have found an addin that does it for me BUT is only available on a trial basis. I have 2 sets of data, ID numbers and modules trained in. I want to generate a list to tell me what module each person has...
  11. C

    Remove duplicates

    I had 2 spreadsheets- both with lists of the same item but containing different information on each item. I have copied and pasted the information together and need to combine information on to one line and delete duplicates. My document is 5 columns wide and about 4,000 rows long. Column...
  12. M

    Merging Rows of Data

    I'm wondering if this is really a Power Pivot question rather than a pure Excel question. I've installed Power Pivot but never used it. Here's the challenge: There are 11,000 rows of which 4,000 are unique. Each entity shows up 1 to 15 times depending on how many orders they've placed. The...

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