Hello,

I am struggling with cleaning my data.

Array

I have panel data regarding banks. I would like keep only the banks that have data available from 2011 to 2017. The issue is that the database does not provide entries if the data is not available. So if data is only available from 2014, there's no missing values in the years before.

How can this be solved in an efficient way?