Forum Discussion
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 ...
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.
Not sure if this will help, but when I want to stack two columns of a table into one, I move the two columns to the end (far right) and then simply unpivot the two columns. This leaves you with an "Attribute" column where the attributes are the two column headers and a "Value" column which is the stacked column of data.
