Hi,
I have a spreadsheet wherein it has different values in multiple rows. Now i would like to combine value of different cells into one cell.
for example.
In Cell A1 it has "Please"
in Cell A2 it has "Help"
in Cell A3 it has "Me"
then A4 is a balnk row
now in Cell A5 it has "Welcome"
and in Cell A6 it has "Guest"
and after that it has a blank row.
Now i want a formula which will give me result in Cell B1 as "Please Help Me"(will combine value of A1,A2 and A3)
and in B5 it will give me "Welcome Guest" (combine A5 and A6)
Like wise i have huge volume of data in my spreadsheet.
Bookmarks