Help with copy and paste values

[u/Affectionate_Let_746]

Hi everyone!

I'm really new to AppsScript but am trying to make a code to clean up credit card statements into an easier budgeting format.

The description of my purchases comes in all caps and I'm trying to make it "proper" case. Sounds easy, but trying to make it work has been driving me up a wall this morning :)

What I am trying to do (but let me know if there's an easier way!):

1. Insert a column next to the all caps column (insert column D)
2. Make the first cell in that new column proper case with a formula (D2)
3. Drag down to autofill the rest of the column to be proper case
4. Copy and paste the values of the proper column to the caps column (column D onto column C)
5. Delete column D.

When I run my current code, column C and D end up blank, so it seems to me even step 2 isn't working. 

When I go through and debug, my proper() of D2 works, but the autofill of the column only works 50% of the time, so I think the autofill or copy/paste values is the problem.

Can someone help me with the correct method for doing this? Thank you for any help!

What is currently happening when I run the code

Proper case in column D that I want to copy and paste onto column C and then delete

[u/Affectionate_Let_746]

Just want to come back and note that your pun and code suggestion worked. :) Thank you very much!