CODEWITHSUNDEEP
excel
Avi
Avi

Reputation: 2283

Grouping rows in table in Excel

I have the following table:

First Name  Second Name Phone
A                B       1
A                B       2
C                D       3
C                D       4

I would like to get the required table (Every values in columns A and B that repeats will appear only in the first line of occurrence): 

First Name  Second Name Phone
A                B       1
                         2
C                D       3
                         4

Upvotes: 0

Views: 1430

Answers (1)

rotgers
rotgers

Reputation: 2010

You can accomplish this by using Pivot Tables.

Out of my head, you have to structure it like this:

Rows

  • First Name
  • Second Name
  • Phone

And it will show it the way you want it. You can change the show/hide for (sub)totals to change the result a bit.

If you want the First name and Second name on the same row, you will have to edit the Pivot Table to use Classic display.

Upvotes: 2

Related Questions