I have a table where I have emergency meeting points. Each building has a meeting point, some buildings have many points, here is an example:
Building | Meet_Points |
123 | 11,12,13 |
124 | 16 |
I would like the table to look like this:
Building | Meet_Points |
123 | 11 |
123 | 12 |
123 | 13 |
124 | 16 |
How would I separate those meet points, and make numerous rows of the same building that has each meet point and all the other attributes carry over to the newly made rows and are the same?