I am trying to develop my first app which is a sports statistic app. I am having trouble trying to use the functionality of the charts component. Here is the challenge:
I have my spreadsheet formatted with each individual player having a row to themselves and their various stats as different columns in the row. Now, the charts component reads and showcases the data in a column while all my data is in a row. I could use another google sheet with some code to change the formatting but then I have trouble with the relation column which I need to relate the data with each player.
What could be a workaround to this?