Am trying to extract a report in excel that shows a commonality between multiple columns. The issue is that a cell may have multiple values in them !

For ex:

vendor-A      DC-Subnets      port-y
              server-2        port-a

vendor-A      DC-Subnets      port-y

vendor-B      DC-Subnets      port-y

vendor-C      server-1        port-x
vendor-C      server-2        port-a 

Is this possible in Excel 2013 ? or do i need to install Power Query to my version of Excel ?

Any advise or insight is much appreciated.

migrated from security.stackexchange.com May 17 at 19:33

This question came from our site for information security professionals.

  • What are you trying to do, exactly (It may help to provide expected result)? and what exactly is your question? – cybernetic.nomad May 17 at 19:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy