Merging two files based on the values of one columm
I have two .csv files which share one column header, which is WELL POSITION, and I would like to merge both files into one. Also, one of the files have two columns in which there are individual values separated by a vertical line (|). I would need to format that .csv file so that I have each of that values in a single row. I send attached the two files I mention.