Split Row into 2

[DaveCos]

Hello,
I have a set of data that is representative of a transaction between a buyer and seller. I would prefer to see the Buyer on one row and the Seller in a second row, there is a record that link them. At present they are on one row and that makes running metrics a little difficult. Is there a simple vba to accomplish the following:
insert a row,
copy above row,
repeat until the last row?

Thank you

Dave

[PaulM100]

Here you can find some macros to insert a blank row and copy data into it:
https://superuser.com/questions/1059...o-row-under-it

[CK76]

Hmm?
Looking at your sample... it is separated into two lines... Albeit bit of redundancy in data.

Ex:
Line 1 - BrownBag sells to GreenGrocer 2500 cases of apples for $2,515.04
Line 2 - GreenGrocer buys from BrownBag 2500 cases of apples for $2,515.04

So line 2 is same as line 1. Just buyer/seller ordered in different column. Or is this supposed to be separate transaction?

It would help, if you manually mock-up few lines of expected result in the sample...

[DaveCos]

indeed, each line is a distinct transaction. I will change the spreadsheet to show what i hope to accomplish