I was just handed an extremely ugly converted report, and I need to clean this document up. Here’s what we have:
Name Date Item
John Smith 1/1/11 apples
2/1/11 apples
3/1/11 bananas
Susy Williams 1/1/11 bananas
5/1/11 pears
6/1/11 apples
7/1/11 bricks
Not only do I need to copy the names down to fill in the first cell for each row, I also need to eliminate all the spacing. Help! (Thanks.)