If two cells are the same as another row, copy paste 6 cells from that row and replace the null ones

[mlauber71]

@Menoufi not sure if iI do overlook something but can’t you just make a distinct list of all Managers with their L0 to L6 and then just left join this list to the rows which do not have a L0?