Hi TejPal ,

Pls try this

• In cells C5:C9, enter the numbers 10, 20, <blank>, 40, <blank> (<blank> meaning do not put anything in cells C7 and C9).
• Now, in cells D59, enter 50, 60, 70, 80, and 90.
• Highlight cells C5:C9 and copy them. Click in cell D5 and go to the Edit menu and choose Paste Special. This time, put a check in the box that says Skip blanks and click OK

Hope this will clear your doubt for the use of Skip Blank.

Rajender