Google tables automatic function extension?

In the photo, we see statistics for individual players. The individual table on the right is the result of all the tables on the left. My question is, if I add more of these tables, each with more stats that produce a different overall result, how can I easily update the right table without having to manually add individual columns to each function? I hope you understand my question.

1 vote, average: 1.00 out of 1 (1 rating, 1 votes, rated)
You need to be a registered member to rate this.
Loading...
Subscribe
Notify of
1 Answer
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
MrProcess
10 months ago

I don't know what the numbers and terms mean. But the solution seems to me to go in a whole other direction: the data belongs sensibly normalized first and then can be run with pivot tables of any desired evaluations. Even those that nobody thinks about today.

So…

First column: the PV1, PV2, …

Second column: the ACS, KILLS, …

Third column: the Scept1X#DACH, …

Fourth column: the points

is a fifth column for the percentage distributions. As I said, I am completely unclear.

Therefore, the data table is an actual set of numbers. Some data points will have to be duplicated, but this will help you with various.