mysql transposing columns into rows dynmaically in jdbc project

Question

I'm working on a data visualization jsf project where I need to analyse and visualize data.

I have a mysql database table with lots of columns about 50 or more and I would like to write an sql statement to preprocess (transpose columns into rows) this data in code so I can map it to a java class.

Or a java code that would distribute the values of the columns selected some how to my mapped class according to the range of date selected

Below is an image of the raw data.

Desired Transformation

So this way I can map it to a java class to analyze date and values.