View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
circuit_breaker circuit_breaker is offline
external usenet poster
 
Posts: 13
Default Can I run a Query or Pivot Table against this dataset?

Hi,
I have an Excel sheet like this:

User Machine Machine Machine Machine

User1 PC1 PC2 PC3
User2 PC5 PC1
User3 PC2 PC3
User4 PC1 PC4 PC5 PC2
User5 PC3 PC4 PC5

I'd like to know for every single machine, who are the user(s) using
it.
For example, PC1 is used by User1, User2 and User4

Any help is welcome. I was thinking of copying the above into a table
and use SQL.
Thanks.