Data manipulation challenge

[#1]

I have the following data sturctured in the below format (don't ask me why its in this format )

Enhancement	Milestone
E_A
E_B
E_C
	M1
	M2
	M3
E_D
E_E
	M1
	M2

I have request to tag any enhancements that have corresponding Milestones underneath. For example, i wouldn't tag E_A or E_B because they don't any corresponding milestones underneath. However I would tag E_C and E_E.

Hi QV developers,

I have to come up with the below structure:

Enhancement	Milestone	Flag
E_A		0
E_B		0
E_C		1
	M1
	M2
	M3
E_D		0
E_E		1
	M1
	M2

Please advise. Thanks for your time.

Regards

Thomas

[Gysbert_Wassenaar]

See attached example.