Hello all, comfortable with excel but not very advanced skill set. With that being said, I am using Google Sheets. My friends and I have decided to do an NBA wins pool. Essentially, my six friends and I have each picked 5 NBA teams. I have been able to hook into yahoo sports nba standings which can retrieve the team city, wins, loss and win percentage as well as other data points. I want to link each team and the corresponding win loss record to the owners (me and my friends). I am hitting a wall on how to sync it up for two reasons. One, the website has two tables: eastern conf and western conf. Could I merge the two "tables" together from the source code without losing the data source I am looking for a relatively easy fix. Two, I am not sure how to tag the owners to the corresponding team name. As of now I have separate tabs for the eastern conf and western conference. I can add columns and tag owners to the teams name however as the source data updates the owners name dont move with it. This is obvious because the data source doesn't have the owners names. Do I create a logic statement? If so, what would it look like?
Source Data: eastern conf
Here is my data source: this is a manual update which I was able to create pivot table to sum up owners win total wins based on the 5 teams each owner owns.
Pivot Table: I would like to take the source data and create pivot table to reflect something like the below.
Not looking to go crazy but would appreciate any help. Thanks in advance!
Source Data: eastern conf
Here is my data source: this is a manual update which I was able to create pivot table to sum up owners win total wins based on the 5 teams each owner owns.
Pivot Table: I would like to take the source data and create pivot table to reflect something like the below.
Not looking to go crazy but would appreciate any help. Thanks in advance!
