Merge data from 3 cells to one via Google Spreadsheet

bArAsc

Regular Member
Joined
Jun 2, 2015
Messages
269
Reaction score
183
I know it is not related to programming but I think I can get answer here.
How can I merge data from 3 cells to one cell separated by space? I know I can use Power Tools add-on to do it but it is painful to select every 3 cells across spreadsheet with 460k cells. Let me explain.

I get this: before merge.png

and I want to get this:after merge.png
 
Back
Top