Building a Table and showing Data based on a column as a Row

[olsen9]

Example would be Item A, B, C etc is dropdown that we have received certain data.  I would like to have the data associated to it to show like this below.  All data is coming from SharePoint List data

Item A
Data from Columns
Data from Columns
Data from Columns
Item B
Data from Columns
Data from Columns
Data from Columns
Data from Columns
Item C
Data from Columns
Data from Columns
Data from Columns
Data from Columns
Item D
Data from Columns
Data from Columns
Data from Columns
Item E
Data from Columns
Data from Columns

[Tom_Y · Accepted solution]

Have you tried a Maxtrix Visual and putting everything in "Row".

[Fowmy]

@olsen9 
Are you expecting you output to be as follows?
Share  a dummy set of data that represent your actual data, this could be done in Power Query.

tem A	Data from Columns
tem A	Data from Columns
tem A	Data from Columns
Item B	Data from Columns
Item B	Data from Columns
Item B	Data from Columns
Item B	Data from Columns

[olsen9]

Actually that's how it's listed now, they want it just like how I have it above.  Item A has to be a row header with all the data associated below, then Item B based on alphabetical.