On May 4, 10:55 am, Sriram wrote:
I want to know whether we can copy multiple columns, and paste them into a
Single column, where all the copied values appear one below the other/
eliminating the Blanks...

Example:
A1 = "All we need"
B1 = "is love"

C1 = concatenate ( SUBSTITUTE(A1;" ";"") ; SUBSTITUTE(B1;" ";"") )

OK? Check Helop on TRIM, CLEAN, SUBSTITUTE functions.
Mitja

PS: You might need to change ; to , depending on regional settings.