Excel is pretty useless at time. If I have 10,000 rows with the first column sorted, and several of those columns have an identical value, then it's impossible group the whole table with one click, and turn this..... aaa aaa aaa bbb bbb ccc ccc ccc ccc into this.... aaa ^ bbb ^ ccc ^ The ^ would be an icon that would allow me to collapse or expand each group on demand. Yes, there is group functionality in Excel, but it requires a function, and it forces me to use things like "sum" or "count" that I have no use for. It's all very clumsy designed.
Thanks so much Jamie!
Thank you so much for this valuable information.
Great tip 👌
Glad it was helpful!
Oh this is so cool! Thanks!
Glad you liked it!
Thank you informative
You're welcome
Excel is pretty useless at time. If I have 10,000 rows with the first column sorted, and several of those columns have an identical value, then it's impossible group the whole table with one click, and turn this.....
aaa
aaa
aaa
bbb
bbb
ccc
ccc
ccc
ccc
into this....
aaa ^
bbb ^
ccc ^
The ^ would be an icon that would allow me to collapse or expand each group on demand.
Yes, there is group functionality in Excel, but it requires a function, and it forces me to use things like "sum" or "count" that I have no use for.
It's all very clumsy designed.
First! :)