Good evening all.
I have a spread sheet that opens another file, sort's data and searches for duplicate data. It then lists the duplicated data in another colum on another sheet. My problem is I cannot remember ( after late nights and some alchohol) how to get rid of the blanks to leave a polished report that is not full of holes. I am begining to unplug my pc ready for the window !
Pleae help I know it is a simple thing but i am tired.
I have a spread sheet that opens another file, sort's data and searches for duplicate data. It then lists the duplicated data in another colum on another sheet. My problem is I cannot remember ( after late nights and some alchohol) how to get rid of the blanks to leave a polished report that is not full of holes. I am begining to unplug my pc ready for the window !
Pleae help I know it is a simple thing but i am tired.