Logic Query

[AS]

Hi Experts,

help me build the logic for this so I have this input data. I need one H=Type line for a single company code. Same company code type=L lines should fall under one H line.

See the input below

Type	CoCode	Name	DocType	Period
H	45B	XXX	--	XXX
L	45B	AA	SDU	2025
L	45B	AA	SDU	2025
H	45B	XXX	--	XXX
L	45B	BB	SDU	2025
L	45B	BB	SDUS	2025
H	27A	XXX	--	XXX
L	27A	CC	GDRE	2025
L	27A	CC	FDre	2025
H	27A	XXX	--	XXX
L	27A	DC	DFRE	2025
L	27A	DC	GDER	2025

Output-

Type	CoCode	Name	DocType	Period
H	45B	XXX	--	XXX
L	45B	AA	SDU	2025
L	45B	AA	SDU	2025
L	45B	BB	SDU	2025
L	45B	BB	SDUS	2025
H	27A	XXX	--	XXX
L	27A	CC	GDRE	2025
L	27A	CC	FDre	2025
L	27A	DC	DFRE	2025
L	27A	DC	GDER	2025

[AS · Accepted solution]

hi folks, I have solved it.