So I have a table and the data comes in through 2 different forms. the table has a common column and I wanted to use that as my lookup value to combine the row values.
FORM A fills in the data in columns A B C
FORM B fills in the data in columns A D E
I wanted to combine the rows based on a column - the end result should be in a single row, and all info will be combined in columns A B C D E.
Also, is it possible to add values?
1st entry - COL A = RED, COL B = 2
2nd entry - COL A = RED, COL B = 3
END RESULT = COL A = RED ; COL B = 5
