@Weedster I have separate lines for each transaction as that will make it easier to spot holdings you have had for three years.
If I sell a holding I make that line pale grey text. Then you can sort by font colour and have those at the bottom out of the way.
I originally had different worksheets for different types of transaction but then decided it was easier to have everything on 1 worksheet and use filters.