You are here: HomeExcelTutorials

# Combine two rows of data into one row

## Combine two rows of data into one row

Price: FREE

My colleague has a data extract that has information belonging to one customer over two rows. What we would like to do is bring each set together so that for each customer there is only one row. I have Googled and searched the forum and the closest thing to this I can find is splitting one row into two using the "OFFSET" function.
This report is received weekly and will end up with around 500 entries so a solution with as little manual input as possible would be much appreciated!
Let me know if you require a sample

Visit publisher's web-site: Combine two rows of data into one row

Category and Tags: ExcelTutorials :

## Related Tutorials

### Combining one row into two

Free: Yes
Tags: Excel › Functions

Is there a way to combine row A and B into one row? For example, I have data in both rows, both numeric and words. Both rows are for the same borrower. I am trying to
combine row A and B into one row that has all the data both A and B had.
I know I can cut and paste each line, but the spreadsheet is large. Any

### Making two lines into one

Free: Yes
Tags: Excel › Functions

Is there a way to combine row A and B into one row? For example, I have data in both rows. Both rows are for the same borrower. I am trying to combine row A and B into one row that has all the data both A and B had.
I know I can cut and paste each line, but the spreadsheet is large. Any

### Macro Help: Combine Rows With Matching Data

Free: Yes
Tags: Excel › VBA

I have a spreadsheet with five columns and hundreds of rows. In Column A and B I have a row of names, and C, D and E contain numerals. The sheet looks like this.
Row 2 Bob Smith 10 2 1
Row 3 Bob Smith 20 4 1
Row 4 Bob Smith 10 4 1
Row 5 Tom Howard 15 5 1
Row 6 Tom Howard 15 5 1
Row 7 Jen Fisher 7 6 1
Row 8 Jen Fisher 12 8 1
Is there a macro that can use the concatenate function to combine columns A and B, and roll up C, D and E if the row beneath matches the row above? The result would look like this.
Row 2 Bob Smith 40 10 3
Row 3 Tom Howard 30 10 2
Row 4 Jen Fisher 19 14 2
Any help would be greatly appreciated. Thanks in advance for your responses.

### Search and Combine Rows

Free: Yes
Tags: Excel ›

I have a spreadsheet that has multiple rows and two Columns. A1 =
Server name, B1 = email address of the server owner. The problem is that servers have multiple owners so one server could have 7 rows. What I would like to do is to concatenate all the email addresses, so I have one row per server.
For example here is the existing data:
Row = Column1, Column2
Row 1 = Server1,
Row 2 = Server1,
Row 3 = Server1,
Row 4 = Server1,
Row 5 = Server2,
Row 6 = Server2,
Row 7 = Server3,
What I would like to have is:
Row 1 = Server1, ; ;
Row 2 = Server2, ;
Row 3 = Row 7 = Server3,
I am not familiar with macros, is there any way of doing this with

### Combine multiple rows to one row

Free: Yes
Tags: Excel ›

If Incident and ID have more than one row I need to combine them.
My Table currently looks like this:
Incident | ID | Charges
1234 | 4321 | A
1234 | 4321 | N
1234 | 4321 | S
1800 | 8548 | A
1900 | 5479 | S
I want it to look like this:
Incident | ID | Charge 1 | Charge 2 | Charge 3

## Related Applications & Scripts

### DataTable or Data Grid

Display of data through DataTable facilitates data management: - The rows can be ordered by clicking on the header of the column that you wish to order by. - You can set your own table size: set width, height, or both. If you set the size, scrolling bars will be shown when the amount of data requires it. - For tables with a high number of rows: Rows can be separated in pages, thus allowing to move between pages; you can also change the amount of rows per page; - Each row in the table will show a column defined by user - either Delete the row, or Edit it. Packaged into a Dreamweaver extension. No hand coding needed.

### SamMySql Database Class

Free: Yes
Tags: PHP › Excel Classes MySQL

This class wraps common MySQL database table SQL queries. It can:
- Perform SELECT queries and retrieve a single value, a single row into an array and all rows into a multidimensional array.
- Insert or update rows from a list of fields and values
- Delete table rows that satisfy a condition
- Count records in a given table
- Check if a table record exists with a given field value
- Perform a database search
- Return a certain number of rows of result from database, et

### TreeGrid with Ajax Support

Free: No
Tags: Ajax › Excel Trees

dhtmlxTreeGrid is a cross-browser JavaScript component designed to represent tabular data in a hierarchical view. It is based on our Ajax/DHTML grid control, dhtmlxGrid, and combines tree view and editable grid.
Ajax support and a rich JavaScript API brings great flexibility to the treegrid, allowing you to create completely customizable, dynamic tables with expandable rows. Advanced data entry capabilities make the treegrid more interactive, and let users enter and edit table data in an intuitive way.
The ability to dynamically expand and collapse table rows assigned to the corresponding tree items makes this treegrid control a perfect solution for displaying tables with an unlimited number of rows. To handle large amounts of data efficiently, dhtmlxTreeGrid also provides such features as Smart XML Parsing (renders grid rows dynamically on node opening), Smart Rendering (renders only rows in the visible area), and paging support.

### PDF Merger Splitter

Free: No
Tags: Software › Excel PDF

PDF Splitter & Merger is a handy and user-friendly PDF tool, making splitting and merging PDFs very effortless. Merge PDF documents & files in a group in any sequence to make single organized document. And split single PDF file in to as many files as you need with single pages or any number of pages files. Combine various pdf e-books to make single one or split the pdf file in to lighter files or single pages based on page ranges or page number.
PDF Splitter & Merger is a PDF tool which is developed for easy and nimble access to the useful information in the PDF documents. It is helpful to arrange different files by merging them in a order. It makes the file lighter by selecting the useful pages of file using Splitting function and makes the file easy to handle and transfer. With the ability to split PDF files into separate documents, either by page range or page numbers, and merge an unlimited number of PDF documents into a single PDF file, our solution helps you to gain control over all your PDF files.

### Drag and Drop HTML Tables Rows

Free: Yes

This script applies drag and drop features to HTML tables. It is a nice script to use if you want to enable your users to rearrange rows in a table, example: Articles in a Content Management System(CMS). This script is licensed under LGPL.