Could someone please help with a macro or any other suggestion to format an
Excel sheet. Basically data is downloaded from a bank every week and the
size of the file can vary but the formatting is constant. That is each
record is 7 lines. So first record is line1-7, second record is line 8-14,
third record is line 15-21 and so on.

I need to format the sheet by taking specific column data from this source
Excel worksheet and putting on to another blank sheet.

The formatting required for each record is as follows.

In the attached sheet the source data is on Sheet 1 and the formatted data
is on sheet.

The mapping is that in the source data there are 7 lines per record and in
the destination data there are 2 lines per record.

Some of the destination columns are blank and some have hardcode values. I
am desperate and would appreciate any guidance on the same.


Record
Source Destination Hardcode value if
value not coming from Source Data
A1 'Document'
B1 Blank
G6 C1
F1 D1
E1 Blank
F1 Blank
G1 BLANK
H1 P1

SECOND LINE OF DESTINATION
A2 'Transaction'
B2 BLANK
G3 C2
..
D2 BLANK
E2 BLANK
G4 F2
G2 BLANK
H2 BLANK
I2 BLANK
J2 BLANK
P1 K2
L2 BLANK
G2 M2


The pattern will repeat itself on every 8th line went the new record start.