I am giving a simplified example, but the principle is the same for my problem. In the end I show you my actual case with a screenshot.
There are 100 municipalities. Their borders divide land data. Within each muncipality, there is 10 categories of land use, represented by 10 polygons that are multipart. So there are a total of 1000 polygons in the whole layer. The polygons have an ID-column with ID-numbers (1-100) representing each municipality, and they also have a land use column that show which kind of land use type each polygon is (1-10).
I also have table imported from Excel. It has one column with land use types 1-10 and one column with the same ID-numbers for each municipality (1-100). Is also has 10 columns for each land use type, which shows kg of wood that can be found in each land use type. That means that for each municiaplity, you can find different kg of wood, even though the land use type is the same.
My problem is that when I try to Join Field, I can only choose one column from the table to join the layer. I would like to also join the values of of kg of wood so that they match the land use type in each municipality. I am a newbie to ArcGIS Pro, and don't know to solve it.
Below a picture is added showing happened when I used Join Field without success (in my real case). To the right are six land use types that shows values in kg (phosphorus). The SUBID2016 is the ID-number column and the DETALJTYP column is the land use type column.