Create master file with value one below each other

Hi,

I have a data as below I need the value which is horizontal one below each other.

[TABLE="class: outer_border, width: 287"]

[tr]

[td][/td]

[td]

Saswad

[/td]

[td]

Suraj

[/td]

[/tr]

[tr]

[td]

FROM

[/td]

[td]

407

[/td]

[td]

408

[/td]

[/tr]

[tr]

[td]

ALANDI

[/td]

[TD="align: right"]4370[/TD]

[td][/td]

[/tr]

[tr]

[td]

AHMEDNAGAR

[/td]

[TD="align: right"]7500[/TD]
[TD="align: right"]7500[/TD]

[/tr]

[/TABLE]

I need the data in output as below
[TABLE="width: 500"]

[tr]

[td]

ALANDI

[/td]

[td]

407

[/td]

[td]

Saswad

[/td]

[td]

4370

[/td]

[/tr]

[tr]

[td]

AHMEDNAGAR

[/td]

[td]

407

[/td]

[td]

Saswad

[/td]

[td]

7500

[/td]

[/tr]

[tr]

[td]

AHMEDNAGAR

[/td]

[td]

408

[/td]

[td]

Suraj

[/td]

[td]

7500

[/td]

[/tr]

[/TABLE]

[TABLE="width: 287"]

[tr]

[td]

Is there an excel formula or macro which can extract this result.

Regards,
NM

[/td]

[td][/td]

[/tr]

[/TABLE]

Re: Create master file with value one below each other

Hi,

PFA sample file.

Regards,
NM

Re: Create master file with value one below each other

Hi Zia,

This is just awesome....

Click and flick within seconds got 1000 lines.

Thanks!

Nishal