Forum Discussion
Grouping
Is there a way to group by just the column with the data in it? I have 20k+ rows of data. I need to label in Col A based upon the group in Col AK. I have already sorted the data so that the top row of each group is the one I need to label. I just need a way to see only the first row of each group. I need to see the rows with pink highlight only.
5 Replies
Thank you so much for the help. I wanted to know the process for a long time.
Populate the data table fully, or break down to related tables, then use pivot table to summarize. This way every record has integrity even when sorted differently. Meantime, while sorted by group, you can hide repeat values by conditional formatting: if A2 = A1 set number format = ;;; (hide all). It also looks nice to set table all borders, then clear top border in the format condition. However, avoid reading a large data table when that's what pivot table is for.
https://www.sqlitetutorial.net/sqlite-group-by/
As have 20k+ rows of data,I prefer sql statemnets group by.
Since your data is sorted, you can test for any changes between rows by 'pushing' the data down a row and comparing before and after.
= IF(data <> VSTACK(0, DROP(data,-1)), "Group: "& data, "")To test multiple fields for changes you would need to introduce BYROW and OR functions.
With the information you shared it's virtually impossible to answer your question... See if the following helps in the meantime
- Data formatted as Table named TableSource
- In column [Event ID] formula is (copied down):
=IF( COUNTIF( SourceTable[[#Headers],[Group]]:[@Group], [@Group] ) = 1, [@Group], "" )- Filter [Event ID] unchecking (Blanks)
