Forum Discussion

dfmcintosh's avatar
dfmcintosh
Copper Contributor
Jan 06, 2024

merging two columns with overlapping data

Is there a simple way to merge the first and second column so that only one column of unique values are presented? Hopefully the picture will show what I am referring to. Column A and B have a lot of the same values but also each one has some unique values yet I was able to align them with power query by some miracle of youtube, I just can't get it all the way to where I need to get it without doing it manually. I have many to do so that isn't going to be a long term solution. Any help is appreciated. Thanks, Devin 

excel

3 Replies

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Jan 06, 2024

    dfmcintosh 

    I do not understand the question.  Column B is a unique list of all the values in the dataset comprising columns A and B.  Were it not, the 365 formula would return such

    = UNIQUE(TOCOL(data, 1))

     

    • dfmcintosh's avatar
      dfmcintosh
      Copper Contributor
      Jan 06, 2024
      Maybe the second picture will explain it a little better. I don't know why at the end of the table there are a bunch of out of sequence zip codes and values that aren't in Column B.

Resources