I apologize for my ignorance. I just am not familiar with pivot queries AT ALL and all the examples I find seem about as clear as mud. I have table that returns GroupName and ID Numbers. 

For Example:

```
SELECT GroupName, IDnumber FROM do.Table_1

```

Returns

```
GroupName                IDnumber
1                          8395
1                          A660
1                          8396
1                          A661
2                          8398
2                          A662
2                          8399

```

What I want is something more like this:

```
GroupName              ID1     ID2   ID3   ID4
1                      8395   A660  8396   A661
2                      8398   A662  8399   NULL

```

How can I do this? Pivot query? Some other method?

I am open to suggestion and appreciate any help you could provide.