Would Like Know Excel Function Use Merge Identities Together Fill Missing Data Row Words W Q43883583
I would like to know which Excel function to use to mergeidentities together to fill missing data in the row. In otherwords, I would like to take the following 4 rows:
And end up with 2 consolidated rows like this:
What formula can I use to do this? The combined “fruit” and“initial” identities are what need to be matched against eachother, and then “color” and “quantity” need to be merged. Thanks inadvance for any help and advice!
A 4 Fruit Initial Color Quantity 5 Apples 6 Bananas 7 Apples Red Yellow B A 8 Bananas B 10 A Initial Color Quantity 4 Fruit 5 Apples 6 Bananas B Red A 2 Yellow Show transcribed image text A 4 Fruit Initial Color Quantity 5 Apples 6 Bananas 7 Apples Red Yellow B A 8 Bananas B 10
A Initial Color Quantity 4 Fruit 5 Apples 6 Bananas B Red A 2 Yellow
Expert Answer
Answer to I would like to know which Excel function to use to merge identities together to fill missing data in the row. In other …
OR