data normalization

Hello community,

I have table for order record (called invoice). But for every item selected I made columns (Item ID, description, Qnty, price & amount). The issue now if I want to record more than 1 item for same record, I duplicated these columns 13 times so I can record 13 items at one invoice. the table is very big and making calculation cells is time consuming and repetitive work. is there a way to separate data or normalize them for easy app. 

thanks allthis is only part of pagethis is only part of pageScreen Shot 2022-06-29 at 6.19.45 PM.png

0 2 185
2 REPLIES 2
Top Labels in this Space