Forum Discussion
Special Merge colums
I have 8 columns, given one row, some are blanked others can be filled.
But, I cannot concatenate them because : two (or more) columns can be filled with the same value. I just need to fill the new column with one occurence of the value.
3 Replies
- v-chenwuz-msft
Community Support
Hi Anonymous ,
You mean there some blank cell in your table. Direct merging them is improssible, so fill these blank with one value has occurened in its column.
You can use fillup or filldown in power query.
Fill values in a column - Power Query | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
