Hi,

I have the data in the excel in the form mentioned below.

P212J762 ANR-HEADER ANR-DATA ANR-TRAILER
P212J329 ANR-HEADER ANR-DATA ANR-TRAILER KONTO4

i want it in the format mentioned below,
P212J762 ANR-HEADER
P212J762 ANR-DATA
P212J762 ANR-TRAILER
P212J329 ANR-HEADER
P212J329 ANR-DATA
P212J329 ANR-TRAILER
P212J329 KONTO4

I guess it can be done with the help of transpose but am not sure.

Please suggest if you guys have a solution.

Thanks to all for the help.