Need help transposing multiple columns in a query

[pwong5]

Hi,

I have a query with columns as follows
TeacherName TeacherID StudentFN StudentLN StudentID Inc#
..Jane.................1...........Nathan......Doe..............10.......1
..Jane.................1...........Judy...........Watson........15......2
...Nick...............2............Lewis..........Carol............16......1
..Mitch................3...........Peter...........Stewart.........17.....1
...Nick................2.............Kevin...........Bacon.........18......2

I want to make it into a query that looks like this
TeacherName TeacherID StudName1 StudID1 StudName 2 StudID2...
...Jane................1..........Nathan Doe....10........Judy Watson.....15.......
....Nick..............2...........Lewis Carol....16.......Kevin Bacon........18....
....Mitch............3............Peter Stewart....17.....

Any ideas? Am open to anything really.

Thank you!