Hi,
I am trying to show some data in a table that is to collect data for testing values and parameters for equipment. The structure is: There is a testing session, where we can test one or more parameters and get a value. Each piece of equipment has a set of configurable parameters it can be tested with. How do I show something like a pivot table. i.e. data from the session table and from the session data table (where the measurements are collected) and it could have a dynamic set of columns as the parameters are configured. Also, can i do conditional formatting?
This is what it looks like in a spreadsheet:
