@Jindon,

I think the workbook the OP uploaded is a little confusing. Look down on row 31. If my code worked then I guessed right about everything above row 31 needs to be deleted an that is what the OP data looks like. So all the data above row 31 is not really there in actual worksheet.