Hi all , if i have an empty cell( eg .emp id) of excel i need to copy the entire row of the missed cell and need to paste in the new excel with addition of new header as exception ! for each itreation i must find out this handle this.
how should i slove this?
i/p file :
excepted result :
i need to get the missed cells of entire row in new excel !
attachment : test.xlsx (12.4 KB)