Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
Using TEXTJOIN would be the easiest way, but if you wanted you can also use a VBA code. Function Concat(rng As Range, Optional sep As String = “https://stackoverflow.com/”) As String Dim rngCell As Range Dim strResult As String For Each rngCell In rng If rngCell.Value <> “” Then strResult = strResult & sep & rngCell.Value … Read more