I have a the first column that has a list of IDs duplicate numbers
i have a second column that has a list of all facilities that are linked to that first column
i want to create a table that list all the associated facilities by the first column where at least one name is in the second column
so I want a count of facility ID and a list of the city name for a facility ID that are filtered on a certain name.
So how many Facility IDs have the word Stockton listed, and a list of the other names in that same facility ID
I need to show the most cities that match up to a filtered city based on Facility IDs
i have a second column that has a list of all facilities that are linked to that first column
i want to create a table that list all the associated facilities by the first column where at least one name is in the second column
so I want a count of facility ID and a list of the city name for a facility ID that are filtered on a certain name.
So how many Facility IDs have the word Stockton listed, and a list of the other names in that same facility ID
I need to show the most cities that match up to a filtered city based on Facility IDs
Facility ID | City |
000144 | ANCHORAGE |
000144 | ANCHORAGE |
000144 | ANCHORAGE |
000144 | ANCHORAGE |
000144 | ANCHORAGE |
000144 | EMERYVILLE |
000166 | W SACRAMENTO |
000166 | YAKIMA |
000166 | YAKIMA |
000168 | WHITE PINE |
000168 | SALT LAKE |
000180 | STOCKTON |
000180 | STOCKTON |
000180 | TACOMA |
000180 | TACOMA |
000459 | SACRAMENTO |
000459 | PORTLAND |
000480 | LODI |
000480 | SACRAMENTO |
000480 | STOCKTON |
000480 | SALEM |
000481 | STOCKTON |
000481 | STOCKTON |
000482 | STOCKTON |
000482 | STOCKTON |
000483 | SAN FRANCISCO |
000483 | SAN FRANCISCO |
000484 | VEGAS |
000484 | VEGAS |
000485 | N VEGAS |
000485 | N VEGAS |
000486 | VEGAS |
000486 | VEGAS |
000487 | VEGAS |
000487 | VEGAS |
000488 | VEGAS |
000488 | VEGAS |
000489 | VEGAS |
000489 | N VEGAS |
000490 | SACRAMENTO |
000490 | SACRAMENTO |
000491 | WEST SACRAMENTO |
000491 | SACRAMENTO |
000492 | WEST SACRAMENTO |
000492 | SAN JOSE |
000493 | ELK GROVE |
000493 | ELK GROVE |
000494 | FAIRFIELD |
000494 | FAIRFIELD |
000788 | STOCKTON |
000788 | WAY |
000857 | VALLEJO |
000857 | PORTLAND |
000857 | PORTLAND |
000857 | PORTLAND |
000857 | PORTLAND |
000866 | FAIRFIELD |
000866 | MULTNOMAH |
000866 | EVERETT |
000866 | SEATTLE |
000866 | SEATTLE |
000882 | FRESNO |
000882 | NAMPA |
000882 | NAMPA |
000882 | NAMPA |
001015 | W SACRAMENTO |
001015 | SEATTLE |