No idea how to title...Sorting in Excel to include group header?

Related1

New Member
Joined
May 22, 2017
Messages
21
Hi! I'm not sure how to phrase my question which makes hard to search for an answer....Can I sort by a grouping under a heading?

I have a sheet that I want to filter (by person), but I want the subheadings (Project name) to be included with the filtering. I can only explain by pictures :rolleyes:

The original spreadsheet:

bhio8g.jpg


When I filter for Holly to see her tasks, I see this (it removes the grouping header):

2qty33a.jpg



I would like to see this so she knows which project the task belongs to.

aubhut.jpg


My only thought would be to add a column with the list of the project name,and create a custom filter which would filter 1st by the person's name and then by the project name.. Oh, that might work. Nope. It put the project names in alphabetical order. I'd like to keep them in the order I have them in. I feel like there is a really simple solution I'm missing here.

Any other ideas?

THANK YOU!!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Can you post a sample file to a third party site so that it can be manipulated. ie. Box.net, Dropbox.com, etc. I believe that this can be easily accomplished using Power Query but personally, I don't like having to try and re-create an existing file and guess as to the structure.
 
Upvote 0
something like this?

ProjectsStephenHollySullivanNamesHolly
Project 1
Task 1XXXProjectsTasksValue
Task 2XProject 1Task 1X
Task 3XTask 2X
Task 4XTask 3X
Task 5XTask 4X
Task 5X
Project 2Project 2Task 6X
Task 6XXTask 8X
Task 7XTask 9X
Task 8X
Task 9XXX
Task 10X

Power Query then Pivot Table from Query table.
You can set Pivot Table according to your needs of course :)

Code:
[SIZE=1]// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    IF = Table.AddColumn(Source, "Custom", each if Text.Contains([Projects], "Project") then [Projects] else null),
    ErrorOut = Table.RemoveRowsWithErrors(IF, {"Custom"}),
    FillD = Table.FillDown(ErrorOut,{"Custom"}),
    UOC = Table.UnpivotOtherColumns(FillD, {"Projects", "Custom"}, "Attribute", "Value"),
    Rename = Table.RenameColumns(UOC,{{"Projects", "Tasks"}, {"Custom", "Projects"}, {"Attribute", "Names"}})
in
    Rename[/SIZE]
 
Last edited:
Upvote 0
something like this?

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Projects[/COLOR][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Stephen[/COLOR][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Holly[/COLOR][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Sullivan[/COLOR]NamesHolly
Project 1
Task 1XXXProjectsTasksValue
Task 2XProject 1Task 1X
Task 3XTask 2X
Task 4XTask 3X
Task 5XTask 4X
Task 5X
Project 2Project 2Task 6X
Task 6XXTask 8X
Task 7XTask 9X
Task 8X
Task 9XXX
Task 10X

<tbody>
</tbody>

YES! Thank you so much!!!!
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top