I have a spreadsheet for tracking sales of two companies. There are approximately 1,000 rows of customers. For several reasons we only receive business from some of the clients each month. For instance from one company there is only 135 customers for the month of April. Each month I have to manually match up the 135 companies with the list of 1,000 customers by dragging them to the appropriate place or use insert cells until they all match. I have two colums - company and individual client, then three columns per month - Orders, Qty, Amount. Is there a way to automate matching up the lists? Here is an example:
Company A Company A
Company B Company D
Company C Company F
Company D Company H
Company E
Company F
Company G
Company H
I want it to look like this:
Company A Company A
Company B
Company C
Company D Company D
Company E
Company F Company F
Company G
Company H Company H
Thanks for your help!
Bookmarks