I have this:

```
-----A-----|-----B-----|-----C-----
1|cherry |apple |banana
2|kiwi |banana |cantaloupe
3|peach |grape |peach
4| |peach |watermelon
5| |strawberry |
```

I'd like this:

```
-----A-----|-----B-----|-----C-----
1| |apple |
2| |banana |banana
3| | |cantaloupe
4|cherry | |
5| |grape |
6|kiwi | |
7|peach |peach |peach
8| |strawberry |
9| | |watermelon
```

Basically expand each column according to what's in the column, and collate the like elements on their own line. (Assume each column is sorted.)

I've been doing this manually by playing cut-paste Ginsu chef, but was wondering if there's an automated way? (I have Excel 2007 but will be getting Excel 2010 shortly.)

Alternatively, is there another tool better than Excel for this purpose?

Thanks for your time.