It seems that currently only Google Sheets allows you to copy non-contiguous cells, i.e., cells between rows hidden by table filters, to visible cells in another column of the same table that also has filters. (In other words, it copies and pastes into the portions visible to the user in the filtered table and not into the hidden rows.)