Design is best, but when you're stuck with an existing data structure, it helps to know how to work around trouble. Susan Harkins explains.

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

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

In Microsoft Excel and other popular modern spreadsheet programs, text and numbers are displayed in a rectangular grid of cells. Generally, every cell in a row or column has the same size, so you ...