Combine Two Lists (All Columns)

Mar 29, 2013

excel help.xlsx

I would like to combine these two lists (all of the columns).

View 4 Replies


ADVERTISEMENT

Excel 2003 :: Combine Two Lists

Dec 10, 2013

VBA code to combine two list as follows :

View 2 Replies View Related

Combine Two Lists To Form Single Unique

Mar 18, 2010

Is it possible to produce one unique list from two, and preferably in alphabetical order, without resorting to VBA? i.e. a formula solution.

I've attached a sample.

View 7 Replies View Related

How To Compare And Combine Data From New And Old Product Lists

Mar 19, 2014

I have two spreadsheets full of products one of new products and the other of old products. I want to filter out the old ones that are discontinued but keep the ones that are still there. The old list has data I want to preserve for the new listings that would be duplicates from the old ones. I want to delete the new listings that already exist in the old list. I'm not sure exactly how to do it. I tried to delete dups based on product id or name but I'm afraid it's deleting entries I want to keep. Both lists contain over 5000 products each. I need to compare two lists and filter out the old products then work on removing the dupes.

View 3 Replies View Related

How To Combine Multiple Columns Into Long List Of Results In 2 Final Columns

Oct 15, 2013

I have a need to combine multiple columns into a long list of results in 2 final columns. Here is my example...

Current layout with varying number of data points per row...

ColumnA | ColumnB | ColumnC | ColumnD | etc...
example1 | Test1 | Test2 | Test3 | Test4
example2 | Option1 | Option2
example3 | Number1 | Number2 | Number3 | Number4 | Number5

Desired Result

ColumnA | ColumnB
example1 | Test1
example1 | Test2
example1 | Test3
example1 | Test4
example2 | Option1
example2 | Option2
example3 | Number1
example3 | Number2

and so on and on and on until all rows have been filled in down the file...

Is this possible?

View 4 Replies View Related

Compare 2 Lists - 6 Columns

Mar 20, 2012

I need to compare 2 lists (each list has 3 columns [first name, last name and email address).

I am trying to compare columns A(incl. First name), B(incl. Last name) and C(incl. email address) to columns D, E and F.

D, E, and F are also First name, Last name and e-mail address respectively.

I need to compare A, B, and C to D, E, and F and find duplicates and highlight them.

View 1 Replies View Related

Combine Many Columns To One

Nov 17, 2009

Essentially need a macro to combine the columns into 1 column.

Need a Macro to put everything in each "box" into one column, for example CU is the end of the first box, CV to GP is the second box ect. Essentially a box is the row where the yellow line is to the column where the yellow column is.

The problem is the setup of these colums change, sometimes they are bigger sometimes smaller and the spaces beneth it change. Sometimes I might have a column which goes to row 18 followed by 3 blank rows then the yellow box

I first design the first colum then select that and drag across to complete the rest ( my real file has links ect )

So I need a macro in which it can scan the first column up to the yellow line then put everthing within a "box " into 1 column, each )

then repeat the same process for other boxes with each box being put in its own column ( preferablly leaving an empty column in between )

THe file itself will help clarify any problem, if this request is not possible if it could combine every column into 1 column ( along with the spaces to the yellow line ) that would help also, i could manually cut each box into another column then.

View 10 Replies View Related

Combine The Columns

Dec 3, 2006

I need to find a way i can easily combine a1, b1, c1, d1, and so on, about a 100 of the, i need to combine, each one has different text that needs to become together. I know one forumula =a1&" " &b1&" " &c1, but doing that for about 100 colums, would take for ever, is there a easier way?

View 12 Replies View Related

Comparing Lists In 2 Columns For A Match

May 3, 2009

If I have a column with a list of items, and another column with a different list of items, how can I get excel to check/compare both list and return a value (eg. TRUE) if there is an item that is both lists, or a different value (eg. FALSE) if there isn't?

View 9 Replies View Related

Combine Multiple Columns Into One Row

Aug 26, 2013

I have a spreadsheet that has identical data in column A throughout the worksheet and want to take data in columns F and G and combine them all onto one row. An example of the data is attached.

test example.xlsx

View 1 Replies View Related

Combine Two Columns From Different Worksheets

Nov 22, 2008

I have two worksheets with a column of part numbers. I am trying to combine them in a new worksheet and remove duplicates.

View 7 Replies View Related

Combine Two Columns Which Both Contain A Lot Of Characters

Dec 19, 2009

I have content in two columns side by side. A total of 1650 rows. I am trying to merge the content of both rows using =A1 & " " & B1 however, it is truncating the content I guess because the cells contain too many characters. How do I merge the contents of the two columns successfully?

View 3 Replies View Related

Combine Data From Two Columns

Feb 16, 2007

I am trying to do something that would look at column B and for each value that is the same in any row in column B, it would look to column A and add that value into a text string of all those values in column C separated by commas.

example, If A1=37294 A2=37295 A3 = 37296 A4=37297 A5 = 37298 and B1 = abc B2=ABC B3=ABC B4=XYZ and B5=XYZ I want C1 to result in 37294,37295,37296. And I want C2 to result in 37294,37295,37296 and C3 to result in 37294,37295,37296 and C4 to result in 37297,37298 and C5 to result in 37297,37298.

View 4 Replies View Related

Combine Columns, Intercalate

Jul 12, 2007

I have data in two columns (A and B), which I need to combine into one column (C) in intercalating order: C1 = A1, C2 = B1, C3 = A2, C4 = B2 and so on.....
Is there a simple way to do it ?

View 4 Replies View Related

Drop-Down Lists: Can We Fill 2 Columns At The Same Time?

May 13, 2009

Is there a way to have a drop-down list fill two columns (actually, two adjacent cells) when a selection is made from the drop-down list? Maybe using an array in the source formula?

For instance, let's say I pick a doctor from the drop down list, I would like the doctor's practice to automatically fill the cell next it so that the two always go together correctly. In the lists example below, when I select Dr. Elmer in column A, then I want Internal Medecine Associates to go in column B.

MD Practice
Dr. BartholomewCentral Endocrine Specialists
Dr. Elmer Internal Medicine Associates
Dr. StamfordCardiology Associates

View 5 Replies View Related

Comparing Three Lists - Identify In 3 Separate Columns

Jul 9, 2013

I am working on a project, I have three different lists that I want to compare and I want to identify in 3 separate columns which titles are found on which list.

For example:

Title List 1List 2List 3
ACAROLOGIA x
ACCIDENT ANALYSIS AND PREVENTION x
ACROCEPHALUS x
ACS CHEMICAL BIOLOGY x x x
ACS CHEMICAL NEUROSCIENCE x x x
ACS COMBINATORIAL SCIENCE x x
ACS MEDICINAL CHEMISTRY LETTERS x x
ACS SYNTHETIC BIOLOGY x x x

View 4 Replies View Related

Lists Of Data In Multiple Columns To One Column

Nov 15, 2013

I have a list of data that is currently separated into 5 different columns with a heading. Each item in the list is given a score 1, 2, 3, 4 or N, which is then placed into the appropriate column for that score.

What I want to do is to place the data in another sheet in the same workbook in a single column list separated by the labels from the columns in the first sheet, without any blank rows.

I am sure it would be easier if I could show you the spreadsheet and the result I want to achieve but I cannot see here how I can. I tried to copy and paste, but it only pasted as text.

View 9 Replies View Related

Combine 2 Columns With 3 Choices Into 1 Column?

Feb 18, 2014

I have 2 columns "H" and "I" from line 6 to 409. Each cell may start with AR , MA or a number. If cell H6 starts with AR I would like to put that cell into B6. If H6 does not have AR then I would like to check I6 for AR, and put that into B6 if it's found. If I don't find AR in either I would check them both for MA, and write the cell that finds MA into B6. If the AR or MA are not found then I would want it left blank. I did try

IF(FIND("AR",$H7,1),$H7,IF(FIND("AR",$I7,1),$I7,IF(FIND("MA",$H7,1),$H7,IF(FIND("MA",$I7,1),$I7," ")))) in B7.

View 6 Replies View Related

Combine Data From Multiple Columns

Jan 8, 2014

My workbook contains information about investigations. Each investigation gets a number and a line in the workbook. Many infos are stored: dates, subject, ...

A dynamic table contains all those informations, which allows me to manipulate data pretty easily.

Issue: For one of the characteristics of the investigation (let's say names), several results might have to be entered. For example, one investigation can have 3 different names, the next one only 2 and another one can have 6.

This causes a problem regarding the manipulation of the data.

Right now I have 10 columns "name 1" "name 2" .... and only those who need to be filled are filled. I can't however efficiently manipulate the data. For example, George could have been entered in "name 1" for the investigation 1 and in "name 2" for another investigation. Using a pivottable, to track George I'd have to select him in all 10 columns.

It seems to me the best choice would be to somehow index the names into a single column with each name linked to its investigation number..

With the index function I have 2 issues:

- It starts by going down the 1st column, then goes to 2nd, ... where I'd want all names of 1 row then names of 2nd row.

Solved this with this formula:

I turned my "names" columns in a ranged name "Names"

but - When fields are empty I get 0s. When I try to remove them with an if statement, it'll just give me empty cells. I'd prefer to skip the empty cells.

Also, I don't know how to 'link' them to my investigation number...

I have this (dynamic) table:

investigation number name 1 name 2 name 3
001 George Paul
002 Chris George Suzy

And I want something like this:

Investigation number Names
001 George
001 Paul
002 Chris
002 George
002 Suzy

View 14 Replies View Related

Combine Two Dynamic Columns Into One Column

Nov 13, 2008

i need to take all cells in column A with values and all cells in column B with values and combine them into column C so i can sort and subtotal. Columns A and B may have 2 values or 2000 values.

View 10 Replies View Related

CountIF Combine The Results From Two Columns

Feb 15, 2009

I have two columns A and B. Column A contains 'Machine Nr' and column B contain 'Week Nr'. In cell C1 i want to write a function so that it counts the number of weeks in Column B where week number is 4 AND the machine nr is 1 in column nr A.

Column A Column B
Machine Nr Week Nr
1 4
1 4
2 4
2 4
3 4
3 4

View 10 Replies View Related

How To Combine Two Columns To Make Phone #s.

Feb 1, 2010

I have two columns of numbers. The first is the area code and second is the phone number. How can I combine the two columns to make one with both: as in area code-phone number?

View 3 Replies View Related

Combine Time Scattered In Different Columns?

Mar 9, 2014

I need to combine the time scattered in different columns and align them daywise.

View 3 Replies View Related

Combine Dropbox Selections Into New Columns?

Mar 13, 2014

FFLX9g.jpg

What I'm after is an easier way to get data combined without having to type it all out. If you look above I would like to have A-C actually as dropbox's or listbox's, something I can click, then drop down to the proper name and select it. Then on E I'd like a timestamp for when this action was done with the date and time as shown along with the reason. Then in F I'd like the Name fields combined so I just need to right-click on F and copy/paste into the other program I use.

Maybe one column can just be the names of everyone with a selection box and I click this stuff then when I am done it resets?

View 1 Replies View Related

Combine Data From Multiple Columns In To One

Sep 2, 2009

I have attached a spreadsheet. I have a data set with ID's in column A and data in columns to the right. If an ID has only one entry then there will only be a value in column B if an ID has 2 entries then there will be a value in Columns B and C, if they have 3.......... And so on....

In my attached file I have created a macro that filters each column and copies the values to another sheet. If an ID had 5 entries (B-F) I would want to have 5 rows for that ID. The attached example macro does what I want but the real data has over 50 columns. Is there a more efficient way of doing this?

View 4 Replies View Related

Combine Columns Into Single Column

Mar 5, 2013

I have 100 columns in 1 worksheet, each column has 200 rows, I want to combine all these columns into a single column.

Therefore, Column 101 or a new worksheet Column 1, will have 20000 names.

View 2 Replies View Related

Combine Two Columns And Rows Into One Column

Jan 23, 2014

I need two solutions, if possible. One macro and then a "poor man's way" in case the macro breaks down the road. something where I can do it with copy/paste, formulas etc.

I will just use letters and numbers to make it easer.........

Column A might have 10 rows, with 1,2,3,4,5,6,7,8,9, and 10 as the data.
Column B might have 7 rows with A,B,C,D,E,F and G as the data.

I need column C to have 70 rows, with 1A, 1B, 1C, etc. .......through 9E, 9F through 9G as the data.

View 1 Replies View Related

Combine 3 Sheets Into One / Different Columns But One Column Same In All

Jan 30, 2014

I have three spreadsheets. They all contain different data but each one has a 'Rental Equip ID' column. Is there a way to take these three spreadsheets and consolidate in to one spreadsheet with all the data on one sheet? I have included an example of each sheet. The column headers are in bold. I can send an example file examples if needed.

Rental Dscr
Rental Equip ID
Rental Group
Rental Sub Group
Rental Qty
Rental Cost

BALL JOINT ADAPTERS 4WD
004-0302
13
2834
1
$ 50.22

[Code] ......

View 7 Replies View Related

Combine Multiple Columns Into 1 Column

Feb 3, 2014

I'm trying to combine multiple columns into 1 column in Excel. I've searched a few places but most of them are tailored for a specific sheet and my VBA skills are elementary

My table looks like this (there could be more than 5 columns... it's somewhat dynamic based on the data given). Note that some columns could have no data, and the size may be different, some have 100 rows of data, while others have 5.

Firm A
Firm B
Firm C
Firm D
Firm E

[Code]...

I want to combine these columns into

Consolidated

A
B
B
C
D
E

[Code]...

Is it possible to do this with an Excel formula? If not, a VBA code

View 9 Replies View Related

Combine Columns Of All Worksheets & Add Worksheet Name

Dec 13, 2007

I have about 100 worksheets that I need to combine the data from column A into 1 worksheet and place the name of the worksheet the data is coming from in column B of the combined worksheet. example

worksheet 1 named New York contains the following in column A

11518

11563

11572

Worksheet 2 named California contains the following in column A

93510

90247..............

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved