Forum Discussion
Solved
Building a Table and showing Data based on a column as a Row
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 dat...
Have you tried a Maxtrix Visual and putting everything in "Row".
Fowmy
Super User
Super Userolsen9
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 |
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.