Need an level template

[deepa karthik prabu]

Hi,

I need to prepare an consolidated master data.

sheet 1 has top levels and sheet 2 has top levels in column A and sub levels in column B as below:

sheet 1

A B
apple good for health
banana good for digestion

sheet 2

A B
apple shimla
apple kashmir
apple ooty
banana trichy
banana tanjur
banana madura


Need an output as

A B C D E
0 apple good for health
1 10 shimla 100
1 20 kashmir 50
1 30 ooty 40
0 banana good for digestion
1 10 trichy 12
1 20 tanjur 400
1 30 madura 300


can anyone help me on this please?