I have 2 rows of data and want to combine them into 1 row. Any values that are not in the 1st row but are in the 2nd should be included in the result row, and vice versa. For example, if I start with these 2 rows:
00 07 08 09 1 13 14 15
00 07 09 1 13 14 15 16 18
Then I would like the 3rd row to look like this:
00 07 08 09 1 13 14 15 16 18
How would I go about this? VLOOKUP? MATCH? Something else?
Thanks for your help!
00 07 08 09 1 13 14 15
00 07 09 1 13 14 15 16 18
Then I would like the 3rd row to look like this:
00 07 08 09 1 13 14 15 16 18
How would I go about this? VLOOKUP? MATCH? Something else?
Thanks for your help!