Maybe consider design in added example
Data entry table is designed to make data entry and reading info from there using formulas as easy as possible. For viewing the entered data, you can design as many different report sheets as you need, which display the data read from data entry sheet exactly in format you want. As example I added a possible report sheet too.
|