Find a value in the first column, return first non-zero value in another column

[owumi]

Hello good people,

I am struggling with an excel problem. I have a table with duplicate values in column 1 (which identifies the person), and numbers in columns 2 to 10. If it helps, the column headers (not shown in the examples) are years.

I would like to create a table with no duplicates, which would keep only the first non zero value that appears for each of the data. So if for example I have:


1 0 5 5 5 5 5 5 5 5 5 5 0 0 0 0 0 0
1 0 0 0 0 0 0 0 0 0 0 8 8 0 0 0 0 0
1 0 0 0 0 0 0 0 0 0 0 0 8 8 0 0 0 0
1 0 0 0 0 0 0 0 0 0 0 0 0 3 3 3 3 0
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3
2 0 0 0 0 0 0 0 4 4 4 4 4 4 4 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 4

I would like to end up with:
1 0 5 5 5 5 5 5 5 5 5 5 8 8 3 3 3 3
2 0 0 0 0 0 0 0 4 4 4 4 4 4 4 1 1 4

I have >700 unique rows (people) and 30 columns (years) so I can not do it manually. Thank you so much in advance for any and all help.