如何在表中查找值并在同一个表中插入查找结果？

I created a table from a CSV file. Although the table has all the data we could ever need for this project, the resulting table is not normalized. My task is to clean and normalize this table.I created a table from a CSV file. Although the