Grouping Rows my Common Column Data?

[MayaJaffe]

Hi -

I have multiple rows (specimen) of data with many columns (attributes) and several possible values in each column. I want to group the rows by most common column values.

For example, if I had 4 rows that matched on 5 of the 20 column values, they would be grouped together. If another 6 matched on 4 columns, they would be grouped together next. Once a row has been grouped, it should not be grouped again.

Any help would be greatly appreciated!!

 

[NARAYANK991]

Hi ,

Since no one has volunteered an answer till now , I assume they might help if you uploaded a sample file with enough data in it. Is that possible ?

Narayan

 

[MayaJaffe]

Sure! Attached below is the data i'm working with. I would like to group samples from column A based on the most matching attributes from columns B-Y.

Thanks for your help!

 

[NARAYANK991]

Hi ,

Your requirement is quite complex ; I really do not know how to tackle it.

Certain columns like Cap Texture and Taste have single values , while many other columns have multiple values in each cell ; how do we check for commonality ? Do two rows have a column in common even if one of the values in them matches ? For instance will Mild ; Pleasant match with either Mild or Pleasant or will it match with only Mild ; Pleasant ?

I doubt that this requirement can be resolved in a short time.

Narayan

 

[bobhc]

Would it help if you turned your data into a table, you could then filter on any column you wanted.

 

[MayaJaffe]

Thanks for your responses, ideally I would like columns to match based on any commonalities in the column (i.e. Mild or Pleasant). Is this possible? Thanks!