Finding the "mode" value for text across columns

[NewAlteryxUser0221]

Hi all, 

I have a a list of columns by month and rows by account ID, and text values under each - like below. I am looking to find the most common value for each Account ID for just these six columns e.g., Row 2 would be "Bronze", and place these new most common values in a new column.  

Furthermore, I am looking to exclude all the 'N/A' text values for this analysis. Can anyone help guide me on this? 

So far I have used the Transpose tool to convert all to rows, then selected Account ID by Key Columns, then created a formula to group all the months into a '2021' category, then summarized to find mode, to then join back into the main dataset. But for some reason this is not working, and I can't seem to figure out how to exclude the N/As. 

Any help would be appreciated - thanks! 

Account ID	January 21	February 21	March 21	April 21	June 21	July 21
1	Platinum	Gold	Silver	Bronze	Bronze	Bronze
2	Gold	Gold	Premium	Premium	N/A	Premium
3	N/A	N/A	N/A	N/A	Premium	Premium

[Qiu · Accepted solution]

@NewAlteryxUser0221 
I think you are almost there.

[NewAlteryxUser0221]

Thanks so much! This worked well 🙂 

[murad]

thanks for the solution.

alternatively we can use the Mode function in the Summarize tools