I am spending lots of time editing PayPal CSV files and wondered if any users may be able to offer any tips.
This picture shows how the PayPal CSV is presented when downloaded. As you can see and probably already know the transaction are duplicated. IE: 2 lines for one transaction. I have to copy the PayPal Fee diagonally down to my amount column and have to do this 100’s of times now. For the life of me i cannot figure out a quicker way to copy and paste multiple PayPal fees to the amount column without messing things up, so have to copy and paste them all manually. If there is a way to avoid this i would really appreciate someone sharing.
I have not been using spreadsheets for too long and i am probably missing a simple command or something like that. I just don’t know what to search for to find an answer and hoped one of you could help? Seems so simple yet driving me crazy lol