Help organizing data

[jrafaelm]

Hi Guys,

I would like to paste data in sheet 1 in this format

11111C AAAA JON 02/10/1900 DDD 20145 22/08/1900 POS97 SCH ORD EE 4.94
11111C AAAA JON 02/10/1900 DDD 20145 22/08/1900 POS97 SCH ORD ER 4.94

and the data to be reorganized in sheet 2 this way, if this possible ?

NINO EMPLYR SURNAM DOB PAYPNT PERIOD CONTDTE PREPOST STIND CONTTYPE EE ER
11111C AAAA JON 02/10/1900 DDD 20145 22/08/1900 POS97 SCH ORD 4.94 4.94

Any help will be greatly appreciated.

Many thanks.