Forum Discussion
Merging contents of items in one column to another without losing data
Better if you attach screenshot directly to your post, not everyone will click on the link of unknown source. Even more better to attache simple sample file - from ones who check the screenshot not everyone will repeat it in Excel to illustrate the formula.
You may combine columns into third one with IF() formula applying the logic
if first column cell is empty
then second column cell value
else first column cell value
Enter it for first row, after that select third column till end of the range and Ctrl+D.
Better if you attach screenshot directly to your post, not everyone will click on the link of unknown source. Even more better to attache simple sample file - from ones who check the screenshot not everyone will repeat it in Excel to illustrate the formula.
You may combine columns into third one with IF() formula applying the logic
if first column cell is empty
then second column cell value
else first column cell value
Enter it for first row, after that select third column till end of the range and Ctrl+D.
