I have a problem that I have been trying to solve by looking at many solutions but couldn't find one that would work for me.
Here is the data: I have for many product ID, the inventory for each warehouse. Meaning I have a column for ID, one for warehouse, and one for the inventory.
I want to have a table showing the ID, as well as other information from other tables (for example description), and then split the inventory on different columns for each warehouse. Basically trying to do a pivot table, but I need to keep the versatility of a regular table.
I tried adding a column with the below formula but I'm getting an error.