Cut/Pasting Duplicates Amounts in Excel That are in the Same Row

I'm trying to move repeated amounts in my Excel spreadsheet to the next column over.

The general idea is that each amount that that is correct in our file should have a duplicate right below it. Both of these amounts then need to be moved into a new column, as you can see I've manually shown done a few.

This file has 3,000+ lines, was looking for some help sorting this file. Also, if it helps the items that are correct should be highlighted yellow, with the one below it being highlighted green. This is consistent throughout the whole sheet.

https://stackoverflow.com/questions/66824147/cut-pasting-duplicates-amounts-in-excel-that-are-in-the-same-row March 27, 2021 at 04:50AM