One employee id in 2nd image is spread into more than one column. I want them to be in a single row rather than in split rows. While applying vlookup in 1st image only the value of 1st row gets picked. For emp_key 559584 when I use regular vlookup then from 22nd data is blank in 1st row, so in this case I want lookup to identify and pick data from 2nd row till 23rd and from 24th lookup to identify from 3rd row and so on. Someone please assist.