<div>
Can you post a sample workbook please ?<br />
Gowflow
</div>


<div>
If you make a pivot table of your table and just select asin for the Rows then you will get a 1-column table which has 1 row for each unique asin. You don't have to pre-sort to do this.<br><br>Another approach is to use the Subtotal function on the Data Ribbon, under Outline. You could use the function to get minimum of price, for example, and then just show the subtotal rows. For this you will have to pre-sort.
</div>


<div>
<a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1456443/OfferDetails--3-.csv" rel="ugc">OfferDetails (3).csv</a><br><br>Sure, ill post the worksheet here. Make sure to format the ASIN colomun to Number with no decimal points, then create a custom category with 10x 0s to add leading 0s removed by Excel. I then created 2 level of sort, First by Asin (Smallest to Largest) and then by Price (Smallest to Largest). This is how i originally setup the sheet to view it in a way that makes sense. The Last part was to only keep the Lowest Price or Top most price for that asin.<br><br><a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1456442/example-category.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2020/05_w20/1456442/example-category.png" class="fr-fic fr-dib"></a><br>I then cut the ASIN Column over by price to be the first column for a better viewing setup.&nbsp;
</div>


OfferDetails--3-.csv

example-category.png

200514-Excel-Grouping-and-Sorting-v.xlsx

IT Operations Manager

Isaias Perez

<div>
Thank you so much Gary. I will spend the next hour studying pivot tables, good knowledge to know.&nbsp;
</div>


<div>
<div class="content wysiwyg-content">
I am looking to group a column called ASINS. Group them together only showing the top line. How can i get this done? I sorted them by Least to Greatest but i only need the least most number on top of each group of ASINS. All other data can be collapsed or removed. Please see attached picture. <br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455996/data-grouping.png" target="_blank" title="data-grouping.png (70 KB)"><img alt="data-grouping.png" class="file-block lazyload" style="max-width: 677px;" data-src="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455996/data-grouping.png" /></a>
</div>
</div>


data-grouping.png

I am looking to group a column called ASINS. Group them together only showing the top line. How can i get this done? I sorted them by Least to Greatest but i only need the least most number on top of each group of ASINS. All other data can be collapsed or removed. Please see attached picture. 



Excel, Grouping and Sorting Properly

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.