HELP - Combine columns into one including duplicate counts

Hi Guys, HELP!! :) any help would be apprciated :)   Below is the formula i have found on the site it has achieved half my goal just need the other half and i believe it has to do with the count ...