---
title: "Filling out your column data to match the number of columns in a range – Yagisanatode"
author: "Sourabh Choraria"
date: 2019-11-29T02:09:00+00:00
modified: 2019-11-29T04:48:11+00:00
canonical_url: https://pulse.appsscript.info/p/2019/11/filling-out-your-column-data-to-match-the-number-of-columns-in-a-range-yagisanatode/
markdown_url: https://pulse.appsscript.info/p/2019/11/filling-out-your-column-data-to-match-the-number-of-columns-in-a-range-yagisanatode.md
categories:
  - "Sheets"
  - "Solutions"
tags:
  - "@LifeOfSpy"
  - "yagisanatode.com"
featured_image: https://pulse.appsscript.info/files/2019/11/expand-column-data-to-macth-all-rows-Google-Sheets.jpg
description: "Have you ever experienced the warning about \"number of columns in the data does not match the number of columns in the range\" when trying to set values or paste a range of values back..."
---

# Filling out your column data to match the number of columns in a range – Yagisanatode

![Filling out your column data to match the number of columns in a range – Yagisanatode](https://pulse.appsscript.info/files/2019/11/expand-column-data-to-macth-all-rows-Google-Sheets.jpg)

[![](https://pulse.appsscript.info/files/2019/11/expand-column-data-to-macth-all-rows-Google-Sheets.jpg)](https://yagisanatode.com/2019/11/24/google-apps-script-filling-out-your-column-data-to-match-the-number-of-columns-in-a-range/)

> Have you ever experienced the warning about “number of columns in the data does not match the number of columns in the range” when trying to set values or paste a range of values back into your Google Sheet with Google Apps Script?

Check out this post to see how this script can help you fill out your column data to match the number of columns in a range.

Source: *[Google Apps Script: Filling out your column data to match the number of columns in a range – Yagisanatode*](https://yagisanatode.com/2019/11/24/google-apps-script-filling-out-your-column-data-to-match-the-number-of-columns-in-a-range/)

---

*Published by [Sourabh Choraria](https://pulse.appsscript.info/p/author/scriptgs/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2019/11/filling-out-your-column-data-to-match-the-number-of-columns-in-a-range-yagisanatode/](https://pulse.appsscript.info/p/2019/11/filling-out-your-column-data-to-match-the-number-of-columns-in-a-range-yagisanatode/)*