I have this table in Pentaho. I would like to have my data like this Is there a way to unpivot like this with Pentaho or perhaps a SQL query? Answer Yes, you could use SQL or Pentaho. With Pentaho you use the step Row denormaliser. To use the Row denormaliser, you need to previously sort your rows by the