[Solved] dynamic query to column to row in mysql [closed]

Solution for your problem is to use PIVOT

Try to look at this: Convert Rows to columns using ‘Pivot’ in SQL Server