cool_runnin
05-02-2012, 12:36 AM
Hi all,
I've got a table in Sheet1 with data of for example 100 columns X 10000 rows.
I've got a table in Sheet2 with data of for example 60 columns X 50000 rows.
InbBoth tables I have same strings like: PAB10CL401 (lets say column A in Sheet1 and column B in Sheet2...however those strings are in different orders (rows) in both tables.
I've got one row with PAB10CL401 and in other cell of this row is "+" value and I've got second row with the same string PAB10CL401 and in the same row other cell has "-" value. All in one table. The same thing is in second table. So every string is two times in this one column A or B).
I want to match both tables so that the strings (here: PAB10CL401) and values "+" and "-" will be the same so it will end up in thrid larger table which is consisting of those 2 sorted tables....
What sholud algorithm look a like ?
I believe the 1st criteria should be the string and second the values of +/- from other cell in the row.
From the input data it is clearly visible that not all rows will be matched (2nd table is bigger) but I want to only match what is possible.
I've got a table in Sheet1 with data of for example 100 columns X 10000 rows.
I've got a table in Sheet2 with data of for example 60 columns X 50000 rows.
InbBoth tables I have same strings like: PAB10CL401 (lets say column A in Sheet1 and column B in Sheet2...however those strings are in different orders (rows) in both tables.
I've got one row with PAB10CL401 and in other cell of this row is "+" value and I've got second row with the same string PAB10CL401 and in the same row other cell has "-" value. All in one table. The same thing is in second table. So every string is two times in this one column A or B).
I want to match both tables so that the strings (here: PAB10CL401) and values "+" and "-" will be the same so it will end up in thrid larger table which is consisting of those 2 sorted tables....
What sholud algorithm look a like ?
I believe the 1st criteria should be the string and second the values of +/- from other cell in the row.
From the input data it is clearly visible that not all rows will be matched (2nd table is bigger) but I want to only match what is possible.