Counting codes across multiple fields and re-labeling the codes
I'm a new user and trying to do some code counting aggregation. I have 5 columns of codes (Col1, Col2, Col3, Col4, Col5), and in each there are 20 possible code values for a data record, let's say the possible values fall within 00 to 20. Only 1 possible code per record per column. So data might look like: Rec Col1 Col2…
