Today we are introducing the new tip which is very useful in our basic routine activity, as many time we need to copy the text from the columns which contains blank cells and actually we required only the Non-Blank cells only. Here we have the very easy method by using Go-To Special tool.
Select the data, click on the Find & Select tool in Home Tab, and click on Go To Special option (Ctrl+5) click on the constant option and click ok
Copy the data and paste the data in another column.
Video Link: Watch Video