Formulas > =WRAPCOLS()

How To Use WRAPCOLS() Function in Google Sheets

Description

This function wraps the provided row or column of cells by columns after a specified number of elements to form a new array.

How To Actually Use WRAPCOLS() in Sheets

WRAPCOLS(range, wrap_count, [pad_with])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Learn more about the WRAPCOLS() formula:

Generate a WRAPCOLS() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.