Share via

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
Answer accepted by question author
  1. Herbert Seidenberg 1,201 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 100.8K Reputation points Volunteer Moderator
    2025-07-20T23:24:16.0533333+00:00

    Hi,

    Select range C3:C10 and press Ctrl+G > Special > Blanks > OK. Now press = and up arrow. Press Ctrl+Enter. Select range C3:C10, copy it, right click and paste special > values > OK.

    Hope this helps.

    0 comments

Your answer

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