Attached: If I have a table, and filter the table based on column C. Now in the filtered rows, I would like to copy B2 to A2, and copy B5 to A5, but if I select B2 and B5 at the same time, it ends up I copy B2/B5 to A2/A3.
The output I expect should be: A2=11; A3=2; A4=3; A5=44
The reason is I don't want to copy one cell at a time, I want to copy a lot of cells in the filtered table, and paste them in same rows.
Thanks.
Copy and Paste.PNG
Bookmarks