Make a calculated column from a non-blank of another column

[Anonymous]

Hi, I need help in making a calculated column which extracts the non blank value from different columns. Sample is below, C1-C5 are existing columns and the calculated column should reflect the non blank values from C1-C5.

[qqqqqwwwweeerrr]

Hi @Anonymous 

you can use this function 

get_value = COALESCE(Sheet[column_name],Sheet[column_name],Sheet[column_name])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more interesting solution here: www.youtube.com/@Howtosolveprobem

Regards

[tharunkumarRTK · Accepted solution]

@Anonymous 

Instead of cerating calculated column, you can merge all 5 columns into one in Power Query. 

Multi select all 5 columns and in the right click menu you should see merge option.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[Anonymous]

Hi, I have a follow up question. What if there are rows wherein there are values on two columns of that rows but the values are the same, I only want one value to show when I merge it. How do I do it?

[Anonymous]

This actually did the trick, thank you!