How to make different columns can be continued into 1 column and shown in a new table (Not combine)

[york]

Hi experts:

      The inspectors will input the below original table every day, I hope to create some charts in Report View page to show the defects quantity changes by the inspection date, product name, product type, so I need to create a new table, the new table will create rows by each defect, you can refer to the new table, because there are 9 defects in total in the original table, so the new table will have 9 rows, could you help check how to create the new table? 

Original Table

Inspection Date	Product Name	Product Type	Defect 1	Defect 2	Defect 3	Defect 4
2023/1/1	A	Switch	Box Broken	Soldering Fail	Low Battery	Product Scratch
2023/1/2	A	Switch	Low battery	Product Scratch
2023/1/3	B	Mouse	Product broken	Low battery
2023/1/4	B	Cable	Cable Disconnected

New Table

Inspection Date	Product Name	Product Type	Defect
2023/1/1	A	Switch	Box Broken
2023/1/1	A	Switch	Soldering Fail
2023/1/1	A	Switch	Low Battery
2023/1/1	A	Switch	Product Scratch
2023/1/2	A	Switch	Low battery
2023/1/2	A	Switch	Product Scratch
2023/1/3	B	Mouse	Product broken
2023/1/3	B	Mouse	Low battery
2023/1/4	B	Cable	Cable Disconnected

[Ahmedx]

you need to make a duplicate of the table and then delete the unnecessary column and do what was shown in the video

[Ahmedx · Accepted solution]

watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26Rhn2_9zDDwIf2VC-M?e=TSB5jB

[york]

Hi Ahmedx:

   Thank you very much for the reply! It's clear for me now!!!

   But I still have a question, I don't want to edit the data in the original table, because there are multiple columns in it, so I want to create a new table only contains the Inspection Date/Product Name/Product Type/Defect, could you help tell me how to make it?