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 ro...
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.