Sorting "apples" and "bananas" from one list into two separate lists?

Hi,
I have a master list which contains only "apples" and "bananas" in a mixed order in the first column, and the associated data (e.g. kilograms) in the second column.
I would like to sort the data from this master list and make two separate lists, one with the "apples" data and one with the "bananas" data. I use Excel 2003. Any suggestions would be greatly appreciated.
Please see the attached sample file. Thanks.

lonely707,


Welcome to the Excel Forum.


Detach/open workbook DistributeGroups w1 AB - lonely707 - EF811505 - SDG10.xls and run the DistributeGroups macro.


If you want to use the macro on another workbook:


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Then run the DistributeGroups macro.

This little macro will split your two column data set into as many columns as you have unique values, not just two.

Please Login or Register  to view this content.

I've added it to your sample workbook with a button. Just clear the sheet and drop in your real data, then run the macro.

Jerry,

Nice. One for my archives.

Thanks.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Take a look at this approach as well and let us know if this could work for you.