I'm not certain I understand the goal but is this what you want to see?
If so you would pivot the data
and create a report based on the pivoted values Pivot Data from Columns to Rows
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
ALSF105_v10.2.twbx 167.0 KB