I have a spreadsheet which is about 1500 rows long. There are about a total
of 150 people on it, with duplicates. Each person had a listing for each
piece of desktop software they currently have on his/her system.

The header line is as follows:
Name Org CompName Property# Software/Program

Version Licensed (Y/N) If Licensed, artifact or proof (describe) Comments

It obviously goes all the way across. My boss wants to see a breakdown (I
think a pivot table will be the best way to go about it) based first on the
Program, then the version, and then whether it's licensed or not.

The problem is that not all fields have a value, so the pivot table may not
be the way to go. Can anyone throw out some ideas of how to best present
this? I thought of doing just a custom sort first by program, version, and
then license. But I think there has to be a nicer way to present this data.

Thanks so much!!!

Judi