merge rows

Hi All. I am trying to create a spreadsheet which takes employee swipe times onto a site and gives how many hours they have worked. The format I have gotten it to gives me their name, date and entry on one row and then name date and exit on the second. But how can I combine these into a...

I have a table similar to the image below. Column A has repeated values, while column B has values corresponding to column A. e.g. a single customer can have multiple orders. What I would like to do is combine the rows, so that there is only one row per unique column A value (customer) and in...

The initial part of my query is similar to some other posts (although I am not adept enough at VBA to modify the code as needed to suit my purposes), but because the second part goes beyond what I've been able to find already on the forum, I thought I'd post the whole question here. I'm working...

Hello, I have varies list of equipment, I have done background calculation to determine hourly, daily, weekly, or monthly rate will apply to this equipment. I have "D" for daily, "H" for hourly, "W" for weekly, and "M" for monthly. Based on cell value "W" or "M" I want to merge Week row for...

I am trying to merge rows based on duplicate values in two columns. Specifically, look at the two screenshots below. If entries under Last Name (Column B) and Email (Column C) match in any two rows, then they should be merged. This is what it looks like originally: <tbody> First Name Last...

Hi there :) I am new with VBA and I am trying to develop an excel macro for this topic, but I haven´t been able to find something that would meet my needs as a starting point, hence I am looking for some help to develop an excel macro that will merge rows, below and above an specific cell value...

I have been compiling many many contact lists into a master excel sheet. Many customers were on multiple lists and are now on the master list multiple times (it is a large list) with many columns of categories and contact information. I need to combine duplicates --sometimes 2 duplicates of...

I wonder if any of you can help me. I have a large amount of data taking up over 1000 rows. The data is for entrants results across 4 events (columns C, D, E and F). Sometimes an entrant will take part in 2 or more of the events. Each event they take part in is shown in a separate row. What I...

I need some help writing a macro that will combine duplicate entries and delete out one of the entries. Please see table below: In below table I would like to combine the two entries for 123 on one row displaying all three reasons. I have a lot of data, so it would need to be a macro. Any help...

Good Evening, I have an excel export containing columns A through R. What I need is a macro that will run through to last row of data and merge rows based on like values in certain columns. For example: If Column A,B,C & F match then merge rows. However, some columns may have information...

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...

Merge WB2 data into WB1 then delete WB2. The process creates 2 excel files via CSV, so they are exactly the same format, same exact header. Each workbook has 1 tab. The two Excel Workbooks are in one folder WB1, WB2 - always named the exact same. Need to open WB2, copy all but the header...

Help me fix my contact list! I want each person information into one row. Sometime they have 6rows, mostly 4 like below. Tried doing this manually, but it will take me months, please help me friends. Problem: <tbody> John Doe Oakhill 12345 Ny Karl Doe Appleroad 12345 Jersey...

Hi, I've got a big file broken down into manageable sizes - about 4500 rows each. Each Unique Identity may have 1 to maybe 10/15 rows (varies). Mostly, each row contains one column of non-blank data (some have more than one cell that is non-blank). I want to merge/roll up these rows into 1 row...

Hi, I've got a big file broken down into manageable sizes - about 4500 rows each. Each Unique Identity may have 1 to maybe 10/15 rows (varies). Mostly, each row contains one column of non-blank data (some have more than one cell that is non-blank). I want to merge/roll up these rows into 1...

Hi All, I've been searching and searching and haven't found anything that quite fits my needs besides some 3rd party software which will be a complete headache to get my IT department to install. I've simplified my scenario as my data is dynamic and goes on for hundreds/thousands of rows. Below...

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...

Hello, I am new to this forum. Hope someone could help me with a merging problem in excel. Case: I have some huge workbooks with information like this: I would like the information in the cells into 1 row for each "group", so i want excel to merge the cells downwards until a new cell with...

Need help putting together merging code for the following scenario holding a Code 1 in the top row and a Code 2 in the bottom row of Col A. A..........B..........C.........D...........E...............F............G............H.............I...

Hello, we are getting data exported out of a Time Sheet from multiple Foremen. These Foremen might get the same employee or that employee might go to several different Foremen during the week. It must be a Macro and not a Pivot Table since we need to manipulate the data for different purposes. I...