concatenate rows in excel based on condition

CONCATENATE ROWS IN EXCEL BASED ON CONDITION HOW TO

The CONCATENATE function below concatenates the string in cell A1 and the string in cell B1.

CONCATENATE ROWS IN EXCEL BASED ON CONDITION HOW TO

I know EXCEL's CONCATENATE function is what I am looking for here, but I am not sure how to create the formula to conditionally concatenate based on the contents of the columns.

Please use the 'Mark as answer' link to mark a post that answers your question. Use CONCATENATE, CONCAT, TEXTJOIN or the & operator in Excel to concatenate (join) two or more text strings. In cell A1, I want to display the header names for any column containing data less than a value of 100 separated by a comma.

If you're having difficulties in applying it to your data, please paste your code here so that I can check it out. #'Changed Type' = Table.TransformColumnTypes(Source,) Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText('i45WcjQwMFTSUfJIzSuqVIrVgQsEl+bloQi4JJZlpsAEjIACQfnpqUXIAo45aUWpQCWxAA=', BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta ) in type table ), I've replaced the Source with some sample data, so you just have to paste the code into the advanced editor and will see the results like you've described above: let If you find a reply helpful, please remember to vote it as helpful - Thanks! Please use the 'Mark as answer' link to mark a post that answers your question. Imke Feldmann - MVP Data Platform (PowerBI). Rows', 'Custom', each Table.AddColumn(#'Grouped Rows', 'Custom', each Text.Combine(, ', ')))ġ) Either take the full code and replace all items to match your table/dataĢ) Try to re-create the steps using the UI, but then you have to select the code that is relevant. So just enter Text.Combine(, ', ') into the dialogue of the pop-up-window, then the following code will be generated automatically for the whole step: I find this easy to remember if I imagine that 'each' means that the followingĬommands are executed for each row of the table. In that case, you just have to take the code for the AddColumn-step, that comes after the 'each'. It looks as if you tried to create the solution by using the UI.

Concatenate rows in excel based on condition