Editing 4,000 plant names in a query with 3 identical columns.

[rgrstvr]

I have a spreadsheet with 4,000 plant names, for example one plant name reads "Acer palmatum (Japanese Maple Tree)".



I transposed this spreadsheet into a database.

And then I created a query with 3 columns - "Acer palmatum (Japanese Maple Tree)" - "Acer palmatum (Japanese Maple Tree)" - "Acer palmatum (Japanese Maple Tree)".

And now I want to convert the database into 3 columns - "FirstName" - "RemainingName" - "OtherName" - so I can manually change this plant name for example to "Acer", "palmatum", "(Japanese Maple Tree)".


But when I edit any one of the names - all of fields in that row change whereas I only want the name in one column to change at a time.

[orange]

Plant names follow a standard taxonomy. You might wish to use it when naming your fields. But it depends a lot on what your database is for. Who will use? Under what conditions?
Good luck with your project.

[rgrstvr]

I figured out how to do what I want. I am making the editing on the spreadsheet version which I will the convert to a database. Thank you for your interest.