Splitting up a row!

[JPLHCR]

Say i brought 6 eggs from a supplier "Peter", and i had this logged on an excel sheet the cost of the eggs was £3.00

Columns being :

Brought From
Product
Number of Products
Cost per item
Total cost

And the Eggs would lay out under the columns as :
"Peter" the person i brought it from
Eggs (The product)
6 (The amount of eggs i brought)
0.50p (£3.00 (Cost) / 6 (Number of eggs))
£3.00 Total Cost

So looking at an excel sheet it would lay out like :

Brought From Product Number of Products Cost per item Total cost

Peter Eggs 6 0.50p £3.00


Ok so this is how it is laid out.

Then say "Jay" & "Gary" brought 2 eggs each for £1.00 each (So he made no money on the buying and selling of the eggs)
Therefore
Jay brought 2 eggs costing £1.00
Gary Brought 2 eggs Costing £1.00

And he will be left 2 Eggs in stock still costing £1.00

so as some of these eggs are sold i need to "Split" up the row which currently looks like this:

Peter Eggs 6 0.50p £3.00

to

Peter Eggs 2 0.50p £1.00
Peter Eggs 2 0.50p £1.00
Peter Eggs 2 0.50p £1.00

(The reason why i would need to "split" the rows up is because i haven't sold the whole 6 in one go and i have different buyers.)

So once in this format i would transfer the 2x2 eggs brought by "Jay" and "Gary" to another sheet separate from the eggs that haven't sold yet

So my question is i need a quick way of splitting up :

This

Peter Eggs 6 0.50p £3.00

to

Peter Eggs 2 0.50p £1.00
Peter Eggs 2 0.50p £1.00
Peter Eggs 2 0.50p £1.00

Read more: http://www.microsofttraining.net/pos...#ixzz3562Bixor

[rcm]

could send the samples in excel?

[JPLHCR]

Untitled.png

I'm new to this so I'm not sure how to attach a file. but I have tried to attach a picture that shows the process