I am working with a long database of service providers listed in a table having all the locations in other table. I always work in a very manual way but I wanted to know if you have some good practices or even tricks or techniques to create this intermediate table.
I will probably just match the IDs manually in the new table, using Google sheets, selecting the first providers ID and then typing the locations ID. Is there a better way to improve it? Mainly to avoid changing between tabs so many times.
| Provider ID | Provider |
|---|---|
| Prov Id 1 | Provider 1 |
| Prov Id 2 | Provider 2 |
| Location ID | Location |
|---|---|
| Loc Id 1 | Location 1 |
| Loc Id 2 | Location 2 |
| Provider ID | Location ID |
|---|---|
| Prov Id 1 | Location 1 |
| Prov Id 1 | Location 2 |
| Prov Id 1 | Location 3 |