Record as column name

[Steve_Vega]

Hello, I have a table with a list of categories. Another one with a list of people.

I want to create a capacity table where I can have a percentage value for every category for each people. Ideally every other column will be linked to the categories tables. The layout will be like this:

Categories table:
Name | Other columns

People table:
People | Other columns

Capacity table:
People | Category 1 percentage | Category 2 percentage | Category 3 percentage | Category n percentage | Total capacity (sum)

How can I make this work?

Thanks!

[ScottWorld]

I’m not sure I follow. Can you provide some screenshots?

[Steve_Vega]

Thanks ScottWorld

I want to create a table like this:

Where Person 1 and Person 2 are values linked from a people list table. And the column names Category 1, Category 2, Category 3, and Category 4 are linked from a category list table. The numeric values are percentages I will manually add in this table. Total would be a sum.

[ScottWorld]

Check out the Pivot Table Block.