I would create a third table called “Inventory prices” which links to the inventory item from the Inventory table, links to the customer and has the unique price. Would that work for you?

What i get is something like this

Can i make it like this?

Use case: it is easier to upload the latter format to my ERP system

The excel sheet is what you’re working with currently? Please explain again (with Airtable exmaple) what you’re trying to achieve

Do you have a junction table?

If so, do you want to transform that junction table into a pivot table?

However, you cannot convert the results of the Pivot Table app to an actual table/tab in your base.

If your list of customers is small enough and does not change, you could use the junction table and a conditional rollup field for each customer in your Inventory table.

Yes i do have junction table named “Price List” and looks like this

I dont understand enough about pivot table. But to be simple, i want to have something like this below picture where i can search the customer name easily

Use case:

1. I have to quickly search the price list per item for particular customer


2. I want to upload to my ERP system where the structure as shown in second picture is preferable