Virtual table with columns based on conditions

I have an INVENTORY table with the following inventory data: ProductID; Inventory_Amount; Inventroy_Quantity; Inventory_Days_Old.

ProductID = Product code; Inventory_Amount = Inventory in $ for each product; Inventory_Quantity = Inventory in pieces for each product; Inventory_Days = Number of days each product is on inventory.

I need to create a new table from my INVENTORY table, so that I can have columns based on Days on inventory for each ProductID. This new table should have following columns: ProductID; Inventory_Amount > 30 Days; Inventory_Amount > 60 Days; Invenotry_Amount > 90 Days

Thank you!