Fantastic.... this is what i was looking for.

but the actual data is not available only in single row.... hence request you instead of using only one cell use entire column. because the data is available in entire columns (multiple rows)

also it might contain BLANK rows which should be ignored.

you really reached very close to my actual requirement - THANKS