I've used excel for basics before, but I'm trying to sort through my PayPal transactions so I can do taxes on my eBay sales.


I have tried a few different activity formats but I believe now I found the easiest one to sort. So far I was able to get a list of every incoming Transaction. Each transaction shows up in colum A., but they take up 4 rows a piece.

It it is listed like so:
A
1. eBay. - "Buyers Name" - Payment
2. Date
3. Total amount in ($)
4. eBay - "Buyers Name" - Payment
5. Shipping (or something)

Then repeats next one like in same 5 row format but continues with 6,7,8,9,10 and another qq, 12,1314,15 ect.......

In Microsoft Word I was able to remove all of the 5th ones about Shipping because they had the same exact words and I used the Find and replace button to "Remove all".

So now I have 4 Rows. Row 1 and 4 are identical, but for every set of transactions the "Buyers Name" is different, so I cannot mass delete duplicate because only the first and last word in that row are the same. I can remove all of the duplicates in Excel leaving only one of them but when I remove duplicates it deletes the duplicate Dates as well, which throws off the every 4 is a transaction is a pattern.

I want to make Row 1, and Row 2, and Row 3 all in one row, Preferably in 3 column, so I can use a Total function when I'm finished.

Can anyone help me mass sort these out? Like find a way to make row of 4 be labeled 1,2,3,4, 1,2,3,4 ect so I can filter them out? Or does anyone know how I can seperate
these out in any other way?

I hope I described what I'm trying to do and someone can help, because I'm also going to have to do this 2 more times, for Purchases and Refunds.

I cannot find an easier way to do this at all when I tried a complete transaction list it was a disaster and they had
Multiple, upto 4 transactions per Sale with wield category and both positive and negative amounts....

Any help or links to help I can understand would be greatly appreciated. THANKS.