How can I combine 2 lists of data in EXCEL
clayton33
I have 2 lists of parameter data for multiple different machines. I am trying to combine the data into a single list, but not all of the parameters are present for all machines. Is this possible in EXCEL?
List 1
List 2
Combined List:
patkim
Assumptions.
- You have only these two tables to manage
- Little bit of manual table creation is suggested
- Headings are unique between two lists. i.e. say Machine 4 can exist only either in List 1 or 2 but not both at the same time.
In this example List 1 is in cells C2:F8 and List 2 is at C10:D15
Now first manually create a structure of your table elsewhere. In this example it's created at H2 and thereafter.
Copy Col C (See the second snapshot) Put it in H, remove duplicates and sort it on Col H. Similarly Copy Headers from both Lists one next to other. So you have a structure in place like this.
Now in I3 put the following formula and drag it down below and across along the length and width of the new table or list.
=IFERROR(VLOOKUP($H3,$C$11:$D$15,MATCH(I$2,$C$10:$D$10,0),FALSE),IFERROR(VLOOKUP($H3,$C$3:$F$8,MATCH(I$2,$C$2:$F$2,0),FALSE),""))
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How to pass list of names to be searched by grep using xargs?
- Next: How to remotely terminate bash shell processes but ensure history is saved?
Related
Related Related
- 1
how can i combine 2 sheets with lists based on a single value?
- 2
How can I combine two lists into one long list?
- 3
How can I copy and combine several .txt lists in alphabetical order?
- 4
How can I take out data of lists?
- 5
How can I combine these 2 queries to one?
- 6
How can can I combine two IF statement in Excel?
- 7
How can I combine multiple nested Substitute functions in Excel?
- 8
How can I combine multiple nested Substitute functions in Excel?
- 9
R-programming: How can I change the variable names when I combine lists?
- 10
How do i Combine two Lists in Dart?
- 11
How can I combine multiple columns of the same data into a single column?
- 12
How can I combine 4 columns of data into a single column?
- 13
VB.Net How to Combine 2 Lists
- 14
How can I randomize data in Excel 2010?
- 15
How can I transform this data in R and not excel
- 16
R: How can I convert list of lists data into a dataframe
- 17
How can I combine 2 SQL queries and retrieve a cumulative count?
- 18
How can I combine 2 CSS classes into one?
- 19
How can I combine 2 complex mysql queries
- 20
How can I combine 2 commits into 1 in git in a branch?
- 21
How can I combine code
- 22
How can i combine these lines?
- 23
How can i subtract arbitrary 2 lists in racket?
- 24
How can I randomly seperate a list into 2 lists but with same length
- 25
How can i subtract arbitrary 2 lists in racket?
- 26
Jekyll: Can I combine collections and data files?
- 27
Can I combine like and equal to get data?
- 28
Data Validation From 2 Lists EXCEL 2010
- 29
How to combine data and calculate in Excel with formula
Comments