Could you share an example of your pivot, that you doesn't like?
On the picture I can only see a straight table, that you can make easily in Qlik Sense, just drop the table object onto the sheet.
You can make a table with drill-down dimension to avoid a Pivot.
Example: Drill-down dimension = Gender -> Age ->ID
The height and weight will be the measures.
Gender avg(height) avg(weight)
M 178 80
F 177 55
After drill-down (M selected):
Age avg(height) avg(weight)
21-25 179 81
26-30 177 79
31-35 178 80