SORTING DATA into formatted report

Hi,
i need help in formatting the raw data below in excel
which order by the format as appendix.Could anyone help and provide consult to me how is the steps in facing the senario below......thanks ya.

CLUB ID REJ CODE REASON CARD NO DESC
A001 B02 not used 123456 PAYMENT MADE
A001 B02 use 236544 PAYMENT MADE
A001 R01 use 222336 NO PAYMENT
A001 R01 not used 556687 NO PAYMENT
A001 R01 not used 225544 PAYMENT MADE

APPENDIX:

CLUB ID: A001
REJECT CODE: B002
REJECT REASON : USE
CARD NO DESC
236544 PAYMENT MADE

-------------------------------------

CLUB ID: A001
REJECT CODE: B002
REJECT REASON : NOT USE
CARD NO DESC
123456 NO PAYMENT