Excel: Copying & Pasting Filtered Column A Values to Column C After Filtering Column B

Hello
For some time I have had such strange statements to do in Excel and there is a problem, namely: when I filter one column, say "B" and copy the values assigned in the "A" column, all the values do not stick to the "C" column, why?
what do you say? can you do something ??

Well, that's the nature of Excel ... Probably all filtered rows are pasting, just one below the other, starting with the first visible one. If you remove the filter after this operation, all filtered values from column A should be in column C, only one under the other.

You can't help it, you just have to be careful when using a filter and copying the results.

Instead of copying to column C, you can insert the formula: = A1 (or something similar) and drag it down on the visible rows. Then remove the filter and on the whole C column do: copy -> paste special as values. I usually do it this way myself.

And it is best to copy the entire filtered table to a new sheet without filter and perform further operations on it.

Great thing with this = A1 I was looking for something like that. I am just using this knowledge. thanks