I want to create a pivot table in google sheets which uses "shirts names" as it's columns headers, "people names" as it's rows headers(as showen in the image). The value should be different in every cell - The sheet gets info about a person and which shirt did he take. In the pivot-table's cell aligned with the person's name, and the name of the shirt, needs to be written "used" or "available".
The formula I need is actually the value in every cell in the pivot's table, so every cell needs to somehow understand which column and row is he in.
