Concatenate multiple columns to a single column

Hi Kay_Kalu 

 Unpivot is the way to go here, in power query, select your 'issue key' column then select 'unpivot other columns'

Remove the attribute column as this will just contain the 'comment' column headers.

Also, remove any blanks from the value column.

Next, select 'Group By' in the transform ribbon, group by the 'issue key column and select the operation 'All rows'

This will give you a nested table column for your comments.

Now add a custom column as follows

Text.Combine([Comments][Value], "#(lf)")

This will result in

Remove the 'comments' column and rename 'custom' to 'comments'

I hope this helps! Please give a thumbs up and mark as solved if it does, thanks!