Excel Group feature allows users to group rows or columns. Ungroup is used to ungroup a range of cells or data that were previously grouped.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s ...

There are two situations in which you might need to merge two columns of data in Excel 2013. If you've imported two columns of data from separate sources, you might want to combine them into a ...

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such ...

You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into ...

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.