Blending 2 Spreadsheets

[G_SAND]

Hi All

I have data from 2 spreadsheets I want to blend. There is common data between the 2 but I can't think of a way of getting the data the way I want it:

Master Spreadsheet:

Part1	Level	Part2	Field1
a	0	a	x
a		b	x
a		c	x
a		d	x
a		e	x

 This data is repeated in a similar fashion for multiple parts

Spreadsheet 2

Level	Part2	Field1
0	d	y
	d1	y1
	d2	y2
	d3	y3
0	e	z
	e1	z1
	e2	z2
	e3	z3

Parts d and e are the same as those in the master spreadsheet. I need the header added to SS 2 (which I think is reasonably simple) but then want the data for the parts in SS 2 entered under the parts in the master:

Part1	Level	Part2	Field1
a	0	a	x
a		b	x
a		c	x
a		d	x
a	0	d	y
a		d1	y1
a		d2	y2
a		d3	y3
a		e	x
a	0	e	z
a		e1	z1
a		e2	z2
a		e3	z3

I need to keep both the d and e part numbers from both sheets so they will be doubled up and the 'zeros' in SS2 appear at the start of each of the data sets.

Hope that makes sense.

Thanks

[mborriero]

Glad to hear that it works.

Let me know if you need more support.

Would be good if you could accept the solution, if it works for you.