Would Like Know Excel Function Use Merge Identities Together Fill Missing Data Words Would Q43882564
I would like to know which Excel function to use to mergeidentities together to fill missing data. In other words I wouldlike 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!
D Quantity A B 4 Fruit Initial 5 Apples A 6 Bananas B 7 Apples A 8 Bananas B C Color Red Yellow Quantity 4 Fruit Initial 5 Apples A 6 Bananas B Color Red Yellow 8 Show transcribed image text D Quantity A B 4 Fruit Initial 5 Apples A 6 Bananas B 7 Apples A 8 Bananas B C Color Red Yellow
Quantity 4 Fruit Initial 5 Apples A 6 Bananas B Color Red Yellow 8
Expert Answer
Answer to I would like to know which Excel function to use to merge identities together to fill missing data. In other words I wou…
OR