1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Merge data from 3 cells to one via Google Spreadsheet

Discussion in 'General Programming Chat' started by bArAsc, Mar 24, 2016.

  1. bArAsc

    bArAsc Regular Member

    Joined:
    Jun 2, 2015
    Messages:
    202
    Likes Received:
    69
    Gender:
    Male
    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