Lookup & Reference
★ 30 · ◉ 12 · Excel 365
=WRAPROWS()
WRAPROWS function
=WRAPROWS(vector, wrap_count, [pad_with])
Reshape Tables
Reshape Tables
12 functions for this use case · out of 12 defined
Lookup & Reference
★ 50 · ◉ 10 · All versions
=TRANSPOSE()
How to use the TRANSPOSE function in Excel to switch or rotate cells.
=TRANSPOSE(array)
Reshape Tables
Lookup & Reference
★ 60 · ◉ 10 · Excel 365
=VSTACK()
The arrays to append.
=VSTACK(array1,[array2],...)
Comparation
Reshape Tables
Lookup & Reference
★ 10 · ◉ 9 · Excel 365
=EXPAND()
EXPAND Function
=Expand(array, rows, [columns], [pad_with])
Reshape Tables
Lookup & Reference
★ 50 · ◉ 9 · Excel 365
=HSTACK()
The arrays to append.
=HSTACK(array1,[array2],...)
Reshape Tables
Lookup & Reference
★ 40 · ◉ 6 · Excel 365
=DROP()
DROP function
=DROP(array, rows,[columns])
Sort, Filter & Dedupe
Reshape Tables
Lookup & Reference
★ 40 · ◉ 5 · Excel 365
=CHOOSEROWS()
CHOOSEROWS function
=CHOOSEROWS(array,row_num1,[row_num2],…)
Lookup & Retrieval
Sort, Filter & Dedupe
Lookup & Reference
★ 45 · ◉ 5 · Excel 365
=TOCOL()
Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.
=TOCOL(array, [ignore], [scan_by_column])
Data Cleaning
Reshape Tables
Lookup & Reference
★ 25 · ◉ 5 · Excel 365
=WRAPCOLS()
WRAPCOLS function
=WRAPCOLS(vector, wrap_count, [pad_with])
Reshape Tables
Lookup & Reference
★ 50 · ◉ 4 · Excel 365
=CHOOSECOLS()
CHOOSECOLS function
=CHOOSECOLS(array,col_num1,[col_num2],…)
Lookup & Retrieval
Reshape Tables
Lookup & Reference
★ 45 · ◉ 4 · Excel 365
=TAKE()
TAKE function
=TAKE(array, rows,[columns])
Sort, Filter & Dedupe
Ranking & Top N
Lookup & Reference
★ 30 · ◉ 3 · Excel 365
=TOROW()
Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.
=TOROW(array, [ignore], [scan_by_column])
Reshape Tables