How to count occurrences across multiple columns
I want to count the number of times a value occurs in two different columns my dataset is set up in a way that an order will always have two IDs in the same row. The IDs can repeat in the same column or be in another column, but they will never be in the same row. In the example below, the number of occurrences for "1"…
