so I probably know that the Title isn't formulated properly, but I'll do my best to describe my problem down below.
I have a table in Power Query that has the following columns:
| RecipeName | ICS Group ID and concentration range |
|---|---|
| 00404-18-S | 275752 hazardous-10-20 |
| 00404-18-S | ICG 1-75-80 |
| 00404-18-S | ICG 7-1-4 |
| 00404-18-S | Citric acid hazardous-0-1 |
| 00019-13-G | ICG 8-70-90 |
| 00019-13-G | ICG 7-1-4 |
| 00019-14-G | ICG 8-70-90 |
| 00019-14-G | ICG 7-1-4 |