SQL从另一列的值创建列

I have the following table:

我有下表：

|  id  |         name            |
----------------------------------
|  1   | 236 SRTD - Something 1  |
----------------------------------
|  2   | 236 SRTD - Something 2  |
----------------------------------
|  3   | 236 SRTD - Something 3  |
----------------------------------
|  4   | 387 SRTD - Something 1  |
|  id  |