Problems / small issues in Excel 2016

Hello Guys,

I have a Little issue. It is pretty hard to explain, but i will try.

I have 2 seperated colums. Both are filled up with diffrent CVR numbers. But both of the colums are not full.
I want to have one colum with all of the numbers without the blank Spaces there is between. On the rows which has 2 diffrent CVR numbers, i want to keep just one of them, it doesn't matter.

Can some of you help me out ?

Mathias

Hi MathiasV and welcome to the forum. Please read the forum rules, particularly #1 and change your post title to something more descriptive of your issue. Think in terms of search, what would someone with a similar problem search for to see how to solve their similar issue? Thanks!