Hi
I have a worksheet in Excel 2007, which has the following sample data:
What I want to achieve is the following: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
Which uses the data itself to create column headings and then gets the count of each.***NoName*** adam pete jo sam 2 3 3 2 1
Is this possible?
Thanks in advance...
Bookmarks