Summarize Data from Multiple Columns and Find the Occurrence

[Anirban]

Hi All,

I have a data set with various numbers in different columns (Please refer the input data format text file). 

My goal is to consolidate all the numbers from various columns into a single column and count the occurrence of each of those numbers based on a criteria. Here the criteria is the number should be >=500. (Please refer the output data format text file)

Please let me know how i can do the same. Thanks in advance for the help.

Anirban

[binuacs · Accepted solution]

@Anirban 

[binuacs · Accepted solution]

@Anirban I updated the column1 and Count in the first row

[Anirban · Accepted solution]

Thanks a lot. This works perfectly 🙂