I have a spreadsheet that lookups something like this:
DBM Power AMP
What I want to do is move the first row in each set over to the Power Column (45.6,47.7 and 49).
I also want to move every second row to the AMP column (32.2, 48, 35).
I know I need a for Each loop but don't know how to create it.
I have 250 sets of these.
thanks for your help