How to Concatenate Multiple Rows with Conditions?

[SiddharthB]

Code No.	Sr. No	Customer	Description	List	IF (code)	IF (sr. no)	sum		Textjoin (Description)
1	1	ABC	sentence	x	1	1	2	1
2	2	EFH	sentence	x	1	1	2	2
3			sentence	x	1	0	1	2
4	3	PQR	sentence	x	1	1	2	3
5			sentence	x	1	0	1	3
6			sentence	x	1	0	1	3
7	4	SYZ	sentence	x	1	1	2	4
				x	0	0	0	4
8	5	LMO	sentence	x	1	1	2	5

<tbody>
</tbody>

I need to concatenate (with a line break) the multiple rows (in description column) for each customer having a serial no. so that in the Textjoin colum, there is only one row for each customer and that row has all the sentences (with a line break) in the description column pertaining to each customer.

Is this possible? Help! Thank you

 

[Fluff]

Hi & welcome to the board.
How about

Sub ConcatDel()
   Dim Rng As Range
   
   For Each Rng In Range("C:C").SpecialCells(xlBlanks).Areas
      Rng.Offset(-1, 7).Resize(1, 1).Value = Join(Application.Transpose(Rng.Offset(-1, 1).Resize(Rng.Count + 1)), Chr(10))
   Next Rng
   Range("C:C").SpecialCells(xlBlanks).EntireRow.Delete
End Sub