I have a folder i am i am ingesting into a query and there is 4 tables right now but could be more eventually. They are all the same format however in the first columns are keys that i want to be the headers. The second column is one i want to use to merge with another table so i want that to stay as a column and not be touched. In row one column 3 and all to the right are some state codes and i want them to be a column.`
The main issue is Everything under row 2 down in column 3 to the right i am trying to get it to be transposed however since its a mixture of 4 different tables it is creating more columns that are being duplicates of the first table so for example i have name in the column with the keys then it creates name_1 then name_2. I am not sure how to work around this
The main issue is Everything under row 2 down in column 3 to the right i am trying to get it to be transposed however since its a mixture of 4 different tables it is creating more columns that are being duplicates of the first table so for example i have name in the column with the keys then it creates name_1 then name_2. I am not sure how to work around this
