There are various ways to rectify this, but they usually require you to insert a helper column or type a formula. However ... Then, go back to that cell, and press Ctrl+C to copy it. The aim is to ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results