I have information in Excel on several rows. I want to copy and paste selected cells and keep each cell value on that row that it was copied from. But each time I copy the values they get clustered together on rows next to each other.
I have included an image to illustrate what I want and how it actually turns out. I select the cells in column B with the value "Banana" (B2 and B4). When I paste I want them to look like in column D (D2 and D4). But what actually happens is the result in column F (F2 and F3).
I use Excel 2016.