{"id":15640,"date":"2023-09-01T09:00:00","date_gmt":"2023-09-01T00:00:00","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/blog\/2023\/09\/01\/changing-column-order-and-adding-text-in-apps-script\/"},"modified":"2025-09-15T17:33:00","modified_gmt":"2025-09-15T08:33:00","slug":"changing-column-order-and-adding-text-in-apps-script","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2023\/09\/01\/changing-column-order-and-adding-text-in-apps-script\/","title":{"rendered":"Changing Column Order and Adding Text in Apps Script"},"content":{"rendered":"

This post is a corrected post after AI explains the code included in the book “Google Apps Script 101: Building Work Automation For Free”<\/a>. Added a strikethrough<\/s> when editing what AI has written, and added color<\/span> when edited by author<\/p>\n

Table of Contents<\/h2>\n
    \n
  1. Summary<\/a><\/li>\n
  2. Code<\/a><\/li>\n
  3. Code Explanation<\/a><\/li>\n
  4. Example<\/a><\/li>\n
  5. AI Prompt<\/a><\/li>\n<\/ol>\n

    Summary<\/h2>\n

    This blog post will guide you through the process of changing the column order and adding text in Apps Script. Using the provided code, you will be able to rearrange columns in a Google Spreadsheet and append additional text to a specific column.<\/p>\n

    Code<\/h2>\n
    function colChangeAddText() {\n  const SS = SpreadsheetApp.getActiveSpreadsheet()\n  const T_SHEET6 = SS.getSheetByName('\uc2dc\ud2b86')\n\n  const data = T_SHEET6.getDataRange().getValues()\n  let dataMap = data.map(item => [item[1], item[0], item[2] + '\uc0b4'])\n  Logger.log(dataMap)\n}<\/code><\/pre>\n
    Code Explanation<\/h2>\n
    The code defines a function named colChangeAddText<\/code>. It accesses the active spreadsheet and retrieves a specific sheet named ‘\uc2dc\ud2b86’ using SpreadsheetApp.getActiveSpreadsheet()<\/code> and getSheetByName()<\/code> methods.<\/p>\n
    The getDataRange()<\/code> method is used to retrieve the range of data from the sheet, and the getValues()<\/code> method is used to get the actual data as a two-dimensional array.<\/p>\n
    The data.map()<\/code> function is used to iterate over each row of the data array and rearrange the column order. In this example, the second column is moved to the first position, the first column is moved to the second position, and the third column has additional text appended to its value.<\/p>\n
    The modified data is stored in the dataMap<\/code> variable, and the result is logged using Logger.log()<\/code>.<\/p>\n
    Example<\/h2>\n
    Let’s say we have a spreadsheet with three columns: A, B, and C. The original data looks like this:<\/p>\n\n\n\n\n\n
    Country<\/th>\nName<\/th>\nAge<\/th>\n<\/tr>\n
    USA<\/td>\nJohn<\/td>\n25<\/td>\n<\/tr>\n
    Canada<\/td>\nJane<\/td>\n25<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    After running the colChangeAddText()<\/code> function, the column order will be changed, and the additional text ‘\uc0b4’ will be appended to the values in column C. The modified data will look like this:<\/p>\n\n\n\n\n\n
    Name<\/th>\nCountry<\/th>\nAge<\/th>\n<\/tr>\n
    USA<\/td>\nJohn<\/td>\n25\uc0b4<\/td>\n<\/tr>\n
    Canada<\/td>\nJane<\/td>\n25\uc0b4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    AI Prompt<\/h2>\n
    Rearrange the columns in a Google Spreadsheet and append the text ‘\uc0b4’ to the values in the third column.<\/s><\/p>\n
    Get all the values from Google Sheet with Apps script, change the position of the columns using map, and add text to one column.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
    This blog post will guide you through the process of changing the column order and adding text in Apps Script. Using the provided code, you will be able to rearrange columns in a Google Spreadsheet and append additional text to a specific column.<\/p>\n","protected":false},"author":1,"featured_media":15655,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5,118],"tags":[512,69,542,7],"class_list":["post-15640","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","category-apps-script","tag-ai-assisted","tag-script","tag-map","tag-spreadsheet"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":true},"en":{"title":true,"content":true,"excerpt":true}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=15640"}],"version-history":[{"count":8,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15640\/revisions"}],"predecessor-version":[{"id":17177,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/15640\/revisions\/17177"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/15655"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=15640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=15640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=15640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}