Hi, I have to sets of data.

Data A has all of Data B, but Data B only has some items of Data A. I would like to somehow automatically align the data from these two columns so that blue will be in the same row as blue, green will be in the same row as green, and so on. I'd also like the numbers they are in the same row as to move with them.

For example, if I start out with this:

I would like to end up with this:

As you can see, the rows are aligned with their matching data points and quantities.

Data A has all of Data B, but Data B only has some items of Data A. I would like to somehow automatically align the data from these two columns so that blue will be in the same row as blue, green will be in the same row as green, and so on. I'd also like the numbers they are in the same row as to move with them.

For example, if I start out with this:

Data A |
Qty |
Data B |
Qty |
||

red | 5 | blue | 15 | ||

blue | 6 | ||||

orange | 9 | green | 19 | ||

green | 10 | yellow | 30 | ||

yellow | 3 |

Data A |
Qty |
Data B |
Qty |
||

red | 5 | ||||

blue | 6 | blue | 15 | ||

orange | 9 | ||||

green | 10 | green | 19 | ||

yellow | 3 | yellow | 30 |

## Comment