Excel - Sorting and keeping multiple rows together with the related name.

EcoAxis 376 Reputation points
2020-10-14T09:18:36.99+00:00

Default data is input by date.
32285-excel1.jpg

If want to sort by name for quick view as below, how can make the related rows follow the related name together. Is it possible to do? Please advise.
32322-sort1.jpg

Microsoft 365 and Office Excel For business Windows
0 comments No comments
{count} votes

Accepted answer
  1. Herbert Seidenberg 1,191 Reputation points
    2020-10-14T15:05:16.013+00:00

    Excel 365 Pro Plus with PowerPivot and Power Query.
    Filter with Slicer.
    Oodles of other plays possible.
    http://www.mediafire.com/file/6r9jr12jdniiyzu/10_14_20.xlsx/file
    http://www.mediafire.com/file/su2ugxub70139ho/10_14_20.pdf/file

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.