Combining and selecting text based on critieria

Good afternoon,

I am trying to write a formula that will look at the text data on another worksheet and combine them into a single cell on a separate line and if the entry has more than one it counts and provides a total. I also need to ensure that any blank cells are omitted. Here is the Data I am working with. Each of these lists can contain up to 10 entries of data but I don't want it to add blank lines when the cells are empty.

Solution
4CV CICU
2N MICU
3N NSICU
CSO
CSO
4CV CICU

On another worksheet - I need the data to display like this:

4CV CICU x2
2N MICU
3N NSICU
CSO x2

Not sure if it is possible to get the count next to the entry if multiples are in the list.

Appreciate all the help and advice