Forum Discussion
Solved
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 bet...
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!