Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there any way i can group similar rows in Excel?I tried group option in excel 2007 and it did not work for all entries. I selected the whole column and used group by option. Example:

name sub grade

jill x A

mark y B

jill m A+

I want this:

name sub grade

jill x A

jill m A+

mark y B

Thank you,

share|improve this question
add comment

migrated from stackoverflow.com Oct 27 '10 at 10:03

This question came from our site for professional and enthusiast programmers.

2 Answers

Highlight the three columns and sort them. I think that the first column selected is the one used for the sort operation.

share|improve this answer
    
thanks so much! no idea why i dint think of it!!! such a simple solution :P :) –  jillika iyer Sep 21 '10 at 19:24
add comment

You can use a pivot table to group by the column that provides similarity criteria (the first column, in your example).

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.