SOLVED
Summarize Data from Multiple Columns and Find the Occurrence
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Anirban
6 - Meteoroid
‎01-31-2022
09:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
3 REPLIES 3
binuacs
21 - Polaris
‎01-31-2022
09:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎01-31-2022
09:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-31-2022
10:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot. This works perfectly 🙂
