messy columns

[ALbaKatBall]

Hi there, sorry for the screen shots I couldn't tell how to attach my bi file. I need to combine data that shifts from one column to another. In excel I could just delete manually the blank cells between the data until everything lined up but I'm hoping there is an easier way to do this in power query or power bi. 

I've been researching and searching for this question being answered across all platforms for several hours with no luck. 

I want to combine column 2 and column 3 so that it shows as one column labelled 'Rooms' and has the number '210' all the way down the column. 

Thanks in advance! 

[ALbaKatBall]

Thank you so much! So simple! 

[VijayP · Accepted solution]

@ALbaKatBall 

Immediate easy way is creating a new custom column

Go to Add Column Tab and select custom column

in the custom column formula section 

if [Column2] = "" then [Column3] else [column2]

This gives you a column containing all room numbers together

Hope it helps!