Mapping Issue

Hi All,

I need some help in mapping the below scenario….

Source structure:

Seg1

fld_name

fld_value

Number of occurrences for Seg1 will be 0-99

Target structure:

Seg1

Brand

Seg2

Manufacturer

Example:

Source file

Seg1

Brand

Colgate

Seg1

Manufacturer

Palmolive

Target:

Seg1

Colgate

Seg2

Palmolive

Can I know how to design mapping for the above example….

Thanks,

Vijay