I am trying to connect two tables and the data is not a one to one connection.
Table one is structured as so:
| Job# | Quote | Quote Cost |
|---|
| 12345, 12346 | 500 | $10,000 |
| 12347 | 300 | $7,000 |
Table Two is structured as:
| Job# | Actual Hours | Actual Cost |
|---|
| 12345 | 550 | $11,000 |
| 12346 | 520 | $10,500 |
| 12347 | 200 | $6,000 |
Is there a way to make The Jobs 12345 and 12346 with the , separator link to two different lines so I can pull the Quote values to compare?
Thank you.
