Is a pivot table possible in mysql?

Question

MySQL

Hello!
Straight to the point, no preludes.
Database. It has a note to the workers. The program visualizes the record/schedule/schedule of employees.
With a simple query, I get this result:

Query result example

Is it possible to get something similar?

Desired response from the DB

As a result, the program will look something like this:

only prettier

In any case, I can collect this in the program, but I want to get the maximum already in the response from the database.
I put it in Excel simply because it's faster. mysql database, IDE VS2015, C# language.

Answer 1

It will not be possible to automatically obtain the desired table with an arbitrary number of employees. You can either list all workers in the request, as PrAw wrote , or get lists of workers by time and parse them already on the client.

SELECT `time`, GROUP_CONCAT(`worker`) 
  FROM `table`
  GROUP BY `time`