Hi

I have a worksheet in Excel 2007, which has the following sample data:

Data                     NoName       Name1   Name2   Name3   Name4   Name5   Name6
001.jpg                  ***NoName*** 
002_adam.jpg                          adam
003_adam_pete.jpg                     adam    pete
004_pete.jpg                          pete
005.png                  ***NoName***
006_jo.jpg                            jo
007_pete_adam_jo_sam.tif              pete    adam    jo      sam
What I want to achieve is the following:
***NoName***    adam     pete   jo    sam
           2       3        3    2      1
Which uses the data itself to create column headings and then gets the count of each.

Is this possible?

Thanks in advance...