Grouping data from a colum in another

[Albi]

Dear all,

I really need your help here!!!

I have a really close deadline for a university project, involving also the use of an excel sheet to manage a database of around 3000 thousands lines.

My problem here, is that I would like to group the data of a column (say column A) in another column (say B), under a specific rule.

An example:

..A.....................B
apple................fruits
banana.............fruits
carrot.............vegetables
mango..............fruits
salad..............vegetables
spinach..........vegetables


Thank you all in advance for your help!!!!!

[stanleydgromjr]

Albi,

Welcome to the Excel Forum.

We are not here to do your work (or your homework) for you. Before posting a question or request for help, please put in time and effort on the problem yourself.


Can we see what you have accomplished so far?


To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

[Leith Ross]

Hello Albi,

Welcome to the Forum!

You need to provide more information. There are several ways I can think of to solve the problem. Assuming the "rule" is to group the items in column "A" based upon the value in column "B" then you can simply filter the data accordingly. This manual solution can also be be done in code. Is there requirement you use formulas, VBA, or any means possible to solve this problem?

[Albi]

Thank you for the welcome!

I attach here a cleaned version of the excel sheet.

Column A shows the data I already have, whereas in column B should appear some 'Groups' (Study Associations in the case) depending on the value in Column A. I compiled the first few lines to give an idea of how it should appear in the end.

I have already tried to compile column B using a macro triggering different filters. However, I had problems because sometimes it was overwriting values or leaving some blank cells.

What I need here is some help in writing a macro to compile the whole database.

[Leith Ross]

Hello Albi,

The easiest solution is select column "A" and "B" then sort them by column "B". Do you need to do this in code?

[Albi]

I'm not sure about what you mean.

Anyway, the code would be really helpful.

[Leith Ross]

Hello Albi,

Disregard my last (now deleted). I post a question to you that was for another member. Sory about that.

[Leith Ross]

Hello Albi,

Here is the code. this has been added to the attached workbook.

Please Login or Register  to view this content.