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 .

<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>
[TD="class: xl63, width: 194"]Name[/TD]
[TD="class: xl63, width: 113"]Code[/TD]
[TD="class: xl63, width: 113"]Value[/TD]

[TD="class: xl63"]employee 1[/TD]
[TD="class: xl63"]0924[/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]employee 2[/TD]
[TD="class: xl63"]0932[/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"]employee 3[/TD]
[TD="class: xl63"]0933[/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]3[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]1[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

</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