Im creating a cost document/calculator for my new business, which will contain all products that we provide. There are 3 tables which in future will contain potentially thousands of products, these are "installation costs", "Annual recurring costs" and "monthly recurring costs". I need a formula that creates new "customer friendly" tables, based on the data in my 3 tables. So the 3 customer tables would only list the items we have entered quantities against, and strip out the information that customer doesn't need to see (such as our buy pricing and profit)
Solved by G. J. in 14 mins