Excel WRAPCOLS Function: Turn Long Lists into Multi‑Column Layouts
WRAPCOLS converts a single row or single column into a neat, multi‑column grid by filling down first, then moving right. It’s the column‑oriented sibling of WRAPROWS. If a vector is too long to present in one strip, WRAPCOLS reshapes it into a compact block that updates automatically as the source changes. The syntax is =WRAPCOLS(vector, wrap_count, [pad_with]). The vector is a one‑dimensional range or array. The wrap_count sets how many items appear in each output column before a new column begins. The optional pad_with fills any empty cells when the last column isn’t full; by default, Excel pads with #N/A so you can see boundaries during build‑out. Microsoft’s reference describes the behavior crisply and notes this is a dynamic array function available in Microsoft 365 and Excel for the web.