Trying to Combine Multiple Columns into 1 to show Errors Per Analyst

[femiprado2009]

I have a dataset that shows below.....
Column A shows Analyst,
Column B shows case ID
Column C-G shows Error Codes
The data is pulled in such a way that the Error Codes are in different columns so you can't merge Column C-G. I need to find a way to merge those Columns to see essentially.
How many times an error code comes up per analyst. It is important to note that an analyst can come up multiple times but will have a different case ID

I have tried using a Pivot Table however the data gets scrambled because they are in different Columns, so it makes it hard to track. I have also tried Power Query to Unpivot those columns and match them but unfortunately that also doesn't work. IF functions as well didn't work.

In an ideal world, I want Columns to have Name, Rows will have each Error Code & how many times they occur.

I will appreciate any suggestions on this and how to progress on this Data set.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Reddit
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.