finnstone
asked on
sort excel lists
i have lists of words in excel column across 20k rows
COL A COL B
apple, orange, pear www.fruit.com
beer, wine, rum www.drinks.com
i need it to do this
COL A COL B
apple www.fruit.com
orange www.fruit.com
pear www.fruit.com
beer www.drinks.com
wine www.drinks.com
rum www.drinks.com
COL A COL B
apple, orange, pear www.fruit.com
beer, wine, rum www.drinks.com
i need it to do this
COL A COL B
apple www.fruit.com
orange www.fruit.com
pear www.fruit.com
beer www.drinks.com
wine www.drinks.com
rum www.drinks.com
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're Welcome Finn! Pleased to help :)
ASKER