Merge multiple columns into a single column with condition

Hi all need a help on How to in Excel
I want to merge the comment of ( B4, D4, F4, H4, J4, L4 ) in “N4” and ( C4,E4,G4,I4,K4,M4 ) data in “O4” but the condition is, in N1 & O1 it should be marge as multiple lines in one cell with the same header. (For example please check in attached excel) if any header’s comment reflecting as blank in that scenario the header should reflect but without any comment ( WO & QC coming up with blank comment in N4 and O4).

Arin.xlsx

I have tried with the below formula
In N4 formula “=B4&CHAR(10)&D4&CHAR(10)&F4&CHAR(10)&H4&CHAR(10)&J4&CHAR(10)&L4”
In O4 formula “=C4&CHAR(10)&E4&CHAR(10)&G4&CHAR(10)&I4&CHAR(10)&K4&CHAR(10)&M4”

But with this it is not picking with the header. As in N4 and O4
How to pull the data with the appropriate header. As in N5 and O5

It will be a great help if anyone can help me out

Regards
Arindam

Try this in N4:

=$B$2&":-"&B4&CHAR(10)&$D$2&":-"&D4&CHAR(10)&$F$2&":-"&F4&CHAR(10)&$H$2&":-"&H4&CHAR(10)&$J$2&":-"&J4&CHAR(10)&$L$2&":-"&L4

Drag the formula to O4 and then down as far as needed.

Your formulae do not reference the headers in row 2 so they are not shown

You need ..

=$B$2 & ":-" &B4&CHAR(10)&$D$2 & ":-" &D4&CHAR(10)&$F$2 & ":-" &F4&CHAR(10)&$H$2 & ":-" &H4&CHAR(10)&$J$2 & ":-" &J4&CHAR(10)&L4

Thanks to both of you

You're welcome, glad we could help.