Data retrieval

[DenniBrink]

Greetings! I am looking for inspiration and problem solving skill involving best practices for data retrieval. I have a table listing employees scheduled days and work assignments. The table is organized as such:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Sat
[/TD]
[TD]Sun
[/TD]
[TD]Mon
[/TD]
[TD]Tue
[/TD]
[TD]Wed
[/TD]
[TD]Thu
[/TD]
[TD]Fri
[/TD]
[/TR]
[TR]
[TD]Bob
[/TD]
[TD]NS
[/TD]
[TD]NS
[/TD]
[TD]Clean
[/TD]
[TD]Inspect
[/TD]
[TD]Inspect
[/TD]
[TD]Clean
[/TD]
[TD]Clean
[/TD]
[/TR]
[TR]
[TD]Ed
[/TD]
[TD]Clean
[/TD]
[TD]Clean
[/TD]
[TD]NS
[/TD]
[TD]NS
[/TD]
[TD]Clean
[/TD]
[TD]Inspect
[/TD]
[TD]Inspect
[/TD]
[/TR]
[TR]
[TD]Rick
[/TD]
[TD]Inspect
[/TD]
[TD]Inspect
[/TD]
[TD]Inspect
[/TD]
[TD]Clean
[/TD]
[TD]Clean
[/TD]
[TD]Clean
[/TD]
[TD]Clean
[/TD]
[/TR]
</tbody>[/TABLE]


Currently, I run a macro that filters out the "NS" and copies the names and assigned day. I wonder is there a better way such as pivotal table or a lookup formula. Please share your thoughts.