Hi!
This is not the most elegant of solutions (VBA would probably be).
Select the table and create a pivot table with SITE and CellID as row headings and Count of CellID as the Value.
This generates a table like this:
The first column of this pivot table really has what you are looking for, but not in quite the right format.
Make a copy of this first column and put it (pastespecial/format followed by pastespecial/values) somewhere convenient such as another worksheet.
You can now extract each subgroup of data (manually, I'm afraid) with its Site and associated Cell IDs. Copy each such set and pastespecial/transpose somewhere suitable.
Clunky, but it works.
Alf
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks