This category includes tools to operate on worksheets rows and columns: selection, merging, adding, transforming, deleting etc.

List of tools included in this category:

1. Highlight rows
2. Highlight columns
3. Group/ungroup rows and columns
4. Sort rows/columns randomly
5. Sort range by blocks of rows
6. "Mirror" rows and columns
7. Manage duplicate rows (count, colour, delete)
8. Copy and sort columns in another file
9. Join rows
10. Join columns
11. Split text to columns
12. Insert blank rows
13. Insert blank columns
14. Delete empty, hidden, first N rows/columns
15. Delete partially blank rows
16. Add columns from other sheets (via key columns)
17. Unpivot (transpose columns to rows)
18. Cross text tables
19. Transpose rows by groups
20. Transpose a column by blocks
21. Reconstruct a range by blocks