Are you stuck on Excel or Google Sheets?

I hid a few rows on the top of Pivot table in Excel and cannot unhide them now. I have tried a few ways described in the web but nothing worked out so far. Please could you help?

Hey there. I can't find a easy way to generate a pivot table exactly as i want to see it. I might need some calculated column but i'm never used this feature and i'm not sure.

Hello, I tried to attach my spreadsheet bit it is too large. I built a power pivot table with a customized formula and everything looked really good but when I try and update the information for the new day the only thing that comes up is the error #NUM!. I am struggling understanding why the formula works for data that was in the spreadsheet when I made it but any data that I update it with gives me the error.

need to learn pivot table v look up and h look up

How can I create PIVOT Table for a large data having merged cell and free spaces, please

Tell me details about Pivot tables. Specially where it is used?

I need help with pivot tables, I can provide an example

Pivot Table formats and functions are lost after my file is saved. Even older versions of the file that had opened fine before will not now. What gives?

Hi, I have a problem with pivot table and conditional formatting please help

I have 4 columns of data, with each row showing one set of data. Then another 4 columns of the same type of data, but for the next month, then another 4 for the following month, etc. It is organized like this so it can be pulled into another sheet. However, I want to analyze this data for the whole year, with pivot tables (also charts, etc), but if I make a pivot table of this data, it makes the columns with the same title another group (month, month2, month3...). I am come the data from each month onto another sheet, so that it is all in just 4 columns. Could you help with this