Forum Discussion
Sorting column groups having shared rows?
I recently organized a spreadsheet representing participants in a Ham Radio group. Though there is a base group of regular participants, we often have new folks joining us. I like to maintain a list ...
I'm honored to have contributed the raw data that @Patrick2788 used to demonstrate his very powerful and elegant solution, seriously. I still have much to learn,
A note to Virago regarding Patrick's formula. He entered it as =WrapRows2Dλ(data,10) .. you can change the number of rows in each extracted subset by changing that final number from 10 to, say, 12 -- or any other number that lets you keep a growing database all visible on one output screen. You will need to follow the advice from m_tarler and me to sort the database and keep it separate from the output section. Let the WrapRows function take care of the display.