Forum Discussion

Lenihan's avatar
Lenihan
Icon for Helper III rankHelper III
9 years ago
Solved

append data from two columns only for distinct count.

Hi,  So I have a table of about 25 columns, 35K rows of data. I want to take two of those columns, append the data to make once column of about 70K of data. Then, remove duplicates.   Would this ...
Need Help
  • Lenihan's avatar
    Lenihan
    9 years ago

    Thank you Imke for your patience and assistance. I was finally able to get it using the old copy/paste/paste/merge/remove duplicates way. I was able to get the chart right too - apparently I had the relationship pointing the wrong way. Once I changed the direction, it is now displaying the right values.

Lenihan's avatar
Lenihan
Icon for Helper III rankHelper III
9 years ago

Thank you Imke for your patience and assistance. I was finally able to get it using the old copy/paste/paste/merge/remove duplicates way. I was able to get the chart right too - apparently I had the relationship pointing the wrong way. Once I changed the direction, it is now displaying the right values.

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Lenihan,

 

Great to hear the problem got resolved! Could you accept the corresponding reply as solution to help others who may have similar issue easily find the answer and close this thread?:smileyhappy:

 

Regards