I am importing data from Jira in PowerBi directly from the web. The data contains an unknown number of columns with similar name (for example Comment1, Comment2, Comment3, etc. depending on the maximum number of comments in the issues selected). I don't know how many of these columns will exist and this is variable. Is there a way I can concatenate all columns with the same name ? (so far, I found this general solution) Ideally I would like to concatenate only when there is a value.



Browse other questions tagged or ask your own question.