Hi,

I have a large amount of data downloaded from a banking system which I would
like to transpose, however as there are hundreds suppliers I don't want to
repeat the transpose action for every single one. Can someone help me with
this?

Below is how it is:

[RECIPIENT AMTSGERICHT LUNEBURG]
ACCOUNTNO 106024003
BANKCODE 25050000
NAME AMTSGERICHT LUNEBURG
PURPOSE NZS LG - 15553

[RECIPIENT E.ON BAYERN AG]
ACCOUNTNO 62004312
BANKCODE 70020270
NAME E.ON BAYERN AG
PURPOSE INVOICES 690011186888-07060#9 DEC, 690011026217-070426 #DEC

[RECIPIENT DETEKTEI EISEN]
ACCOUNTNO 311005448
BANKCODE 44050199
NAME DETEKTEI EISEN
PURPOSE INVOICE 1206

[RECIPIENT ASTERIA GV GMBH]
ACCOUNTNO 377978000
BANKCODE 21050000
NAME ASTERIA GV GMBH
PURPOSE NEBENKOSTEN 2007/2008#CGV KUENZELSAU

[RECIPIENT ENSEL-NT GMBH]
ACCOUNTNO 6611750
BANKCODE 56051790
NAME ENSEL-NT GMBH
PURPOSE 6825936

This is how I would like it:

ACCOUNTNO BANKCODE NAME
106024003 25050000 AMTSGERICHT LUNEBURG
62004312 70020270 E.ON BAYERN AG


Many thanks!