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 !
vendor-A DC-Subnets port-y server-2 port-a vendor-A DC-Subnets port-y port-x 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.