Means on Excel

[Luanarocha]

Hello, I have no experience on excel so my question is very basic probably
Basically i have a large data set divided quarterly (e.g 2006q1) and I need to put it yearly doing the means for each variable in a firm-year basis. I have some blank and 0 values. How should I do?

 

[awoohaw]

@Luanarocha , Welcome to the forum. The forum has a tool called xl2bb add in (Link is below). You will get faster responses if you post your data (anonymized for sensitive data) in a mini worksheet using the tool. If you are unable to use the tool please post the data as a table (identify column and row numbers please).
Your data only needs to be a small representative same.

Thanks in advance.