Attach data in one column

[Islam Hamed]

I have this sheet created by H.R. System , you notice that the data of every employee are scattered at various rows .
I can't use these data unless the code of every employee in the same column along with the value belongs to him then I can use pivot table to sum the values for every employee .
I can deal these few lines but the original sheet extended to about 3000 row , so it's impossible to deal with it, until the employee code is copied down to the rows to detect every value to the employee .
Thanks for your time .

Name	Code	Value
employee 1	0924
		1
employee 2	0932
		1
employee 3	0933
		1
		1
		3
		1

<colgroup><col style="mso-width-source:userset;mso-width-alt:7094;width:146pt" width="194"> <col style="mso-width-source:userset;mso-width-alt:4132; width:85pt" width="113" span="2"> </colgroup><tbody>
</tbody>

 

[Scott T]

If I understand what you want to do correctly this should help

https://www.excel-university.com/how-to-flatten-repeat-and-fill-labels-down-in-excel/

 

[Islam Hamed]

If I understand what you want to do correctly this should help

https://www.excel-university.com/how-to-flatten-repeat-and-fill-labels-down-in-excel/

Yes, It's very effective and simple technique , It helps me much
thanks for your time and effort
and sorry for the mistakes in my writing, I am not very good at English