Group multiple rows into single rows with multiple columns

[LuLeBe]

Hello,

I'm currently facing the following problem:
I have a table "classes" with various columns including "date" and "teacher". I want to create a query that outputs one row for all results of the same date, with columns "teacher1" to "teacher6" that'll be filled or contain empty strings based on how many rows there are for that date (never more than 6).

So basically turn this:

date	teacher
05-05-2019	T1
05-05-2019	T2
05-05-2019	T3
04-04-2019	T1

into this:

date	teacher1	teacher2	teacher3	teacher4	teacher5	teacher6
05-05-2019	T1	T2	T3
04-04-2019	T1

I'm unfortunately not very familiar with complex queries and haven't found a solution online that I know how to adapt to my needs.
I would appreciate any help with this very much!

Thank you in advance
LuLeBe

[orange]

Look at theSimilar Threads

links at the bottom of the page for ideas.
Good luck.