CODEWITHSUNDEEP
excelpivot-table
Shaun
Shaun

Reputation: 11

Excel 2013 - Group rows by column value

How do I group rows by column value in Excel 2013, like how you see in a SharePoint list?

For example, if this is my table:

Col 1 | Col 2 | Col 3 | Col 4
-----------------------------
1001  | 1002  | 1003  | 1004
2001  | 2002  | 2003  | 1004
3001  | 3002  | 3003  | 2004
4001  | 4002  | 4003  | 2004

And I group by Col 4, I would like to see the result like this:

Col 4 = 1004

  Col 1 | Col 2 | Col 3 
  -----------------------
    1001  | 1002  | 1003
    2001  | 2002  | 2003

Col 4 = 2004

  Col 1 | Col 2 | Col 3 
  -----------------------
    3001  | 3002  | 3003
    4001  | 4002  | 4003

Is this at all possible in Excel? I tried creating a pivot table but it just creates nested rows, not the view I'm looking for.

Anyone out there who can help?

Upvotes: 1

Views: 2938

Answers (1)

ManishChristian
ManishChristian

Reputation: 3784

Like everyone suggested, use PivotTable. Here I've added helper column in the beginning, you can hide that column if you want to.

enter image description here

Use filter in cell B12 to select other value.

Upvotes: 2

Related Questions