A simple list of student names in Google Sheets can quickly become unwieldy. Whether you’re aiming for a quick seating chart, a visual representation of project groups, or just need to reformat data for clarity, the WRAPROWS function offers a rapid solution. While specialized platforms like Grouper handle group creation better, the WRAPROWS function is your go-to for quick and efficient list organization within Sheets, turning that single column into a neat, table-like array.
WRAPROWS Turns Your List Into a Table
The WRAPROWS function is a valuable tool for any teacher looking to streamline their classroom organization. It allows you to transform a simple list of student names into a structured table, making it easier to create seating charts, organize student groups, and present data in a clear and concise manner.
WRAPROWS(range, wrap_count, [pad_with])
In this example I have a list of student names in column A, starting in row 2. In a blank cell enter the WRAPROWS formula.
=WRAPROWS(A2:A31,4,””)
The single column of student names is magically transformed into a table array of 4 columns. The column is wrapped into rows. The number of rows is automatically generated based on the number of items in the list (range).
Breaking Down the Function
To quickly wrap a list of values into an array, start with an equals sign in a blank cell. Type WRAPROWS( and highlight the list of student names, or whatever you have a list of. This indicates the range of cells you want to wrap into an array. How MANY columns is the next part of the formula. Put a comma and type the number of columns to create in the array. The optional 3rd part of the formula is what value you want to display when there is a lack of items in the list to fill out the table. Use “” to indicate leaving the cells blank.
Randomize the Range of Student Names
If you want to randomize the list of students names in your table, you first need to randomize your list. Highlight the names and locate “Randomize range” in the right click menu.
Quick Crop Add-on
Crop Google Sheets™ quickly. Plus other quick spreadsheet needs such as hide other sheets.
Created by AliceKeeler – Collects NO user data. Completely free
Classroom Applications
The true power of WRAPROWS shines through when applied to everyday classroom tasks. In this section, we’ll explore practical examples that demonstrate how this function can simplify your organizational efforts. You’ll see how easily you can create seating charts, manage student groups, and present data in a more organized way, all with just a few simple formulas.
Read a Row
If you have a Google Form with a lot of questions it can be cumbersome to read the responses in the spreadsheet row. Use WRAPROWS to view all of the responses from a particular student in an easier to read chunk.
Vocabulary Lists
Have a list of vocabulary words that extend off the screen? Use WRAPROWS to display these words as a table.
Student Groupings
The 2nd option, wrap count, is the group size.
=WRAPROWS(range, group size, “”)
Tip: download your student roster and upload to grouper.school to create groups with one click along with the option to add attributes for better groups. Check out my grouping tips.
Creating an Assignment Tracker
Organize a list of assignments into days of the week by creating group sizes of 5. Instead of “” for empty cells, provide the default “No Assignment.”
=WRAPROWS(B1:B10, 5, “No Assignment”)
Choose a Random Name
If you want a quick, and also free, way to choose a name from a list of student names try my Add-on Quick Crop. After installing, locate Quick Crop in the Extensions menu. Under “Other features” is the option of “Spinner Wheel from Column.”
Select a cell in a column. Quick Crop. The spinner wheel option reads the entire column, drops them into a spinner, and selects a random name.
Display Row or Column Data with WRAPROWS
The WRAPROWS function is a hidden gem that can greatly enhance classroom organization, lesson planning, and data management. Whether you’re structuring student lists, planning lessons, or organizing schedules, this function helps transform messy vertical lists into structured, readable tables.
