Excel WRAPCOLS Function: Transform Single-Column Data into Organized Arrays (2025)

Published: January 21, 2025 - 2 min read

Vijay Srinivas

The WRAPCOLS function, new in Excel 2025, converts linear data into organized columns. It’s the solution when you need to display long lists in a more readable format. Whether you’re building a directory or formatting a product catalog, this function helps you create structured layouts without complex formulas.

Create Multi-Column Layouts with WRAPCOLS

The WRAPCOLS function takes your single-column data and automatically distributes it across multiple columns. Here’s how to start:

Set Up Your First WRAPCOLS Formula

Follow these steps to create your first multi-column layout:

  1. Prepare Your Data

Copy

1. Select a blank range in your worksheet

2. Type =WRAPCOLS(

3. Select your input range

4. Specify the number of columns

5. Close the parenthesis and press Enter

Example:

Input Range

WRAPCOLS Formula

Result

A1:A10

=WRAPCOLS(A1:A10,3)

Creates 3 columns from data

Customize Column Arrangements

Fine-tune your layout with these adjustments:

Basic Syntax:

Copy

=WRAPCOLS(array, wrap_count, [pad_with])

Where:

  • array: Your input data range
  • wrap_count: Number of desired columns
  • pad_with: Optional value for empty cells

Example with custom spacing:

Original List

Formula

Result

Item 1

=WRAPCOLS(A1:A9,3,””)

Three columns

Item 2

 

Blank cells filled

Item 3

 

with specified value

Transform Data Arrays Automatically

WRAPCOLS excels at handling large datasets. Here’s what you need to know:

Work with Dynamic Ranges

For lists that change frequently:

  1. Create a Dynamic Range

Copy

Coefficient Excel Google Sheets Connectors
Try the Free Spreadsheet Extension Over 500,000 Pros Are Raving About

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Get Started

1. Name your input range

2. Use WRAPCOLS with the named range

3. Add new items to update automatically

Pro tip: Combine with COUNTA to handle varying data lengths:

Copy

=WRAPCOLS(A1:INDEX(A:A,COUNTA(A:A)),3)

What is the WRAPCOLS Function?

WRAPCOLS redistributes data from top-to-bottom to left-to-right orientation. Think of it as creating a newspaper-style column layout from a single list.

Essential WRAPCOLS Parameters

Master these parameters for better control:

Parameter

Purpose

Example

Vector

Input data

A1:A10

Wrap_count

Column number

3

Pad_with

Fill empty cells

“” or 0

Making the Most of WRAPCOLS

Start simple with basic layouts. Then experiment with different column counts and padding options. The key is finding the right balance for your specific needs.

Ready to take your spreadsheet capabilities further? Connect your Excel sheets to live data sources with Coefficient. Get started now and transform how you work with data.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 500,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Vijay Srinivas GTM @ Coefficient
Vijay Srinivas is an engineer turned marketer who loves to dabble in data and has 6 years of experience in GTM for Startups and SaaS orgs. Building his skills currently to be a PLG & spreadsheet expert.
500,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 50,000 Companies