Forum Discussion
messy columns
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!
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!
2 Replies
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!
Thank you so much! So simple!
