Bring data from header fields to the columns

[AG]

Hi all,
I need help on automating the following:
everyday I get as EXCEL report in the format as described below
title1: abc
title2: xyz
1 Name1 Id1 Qty1 Cust1 Diff1
2 Name2 Id2 Qty2 Cust2 Diff2
3 Name3 Id3 Qty3 Cust3 Diff3
...
...
title1: pqr
title2: def
1 Name4 Id4 Qty4 Cust4 Diff4
2 Name5 Id5 Qty5 Cust5 Diff5
the number of records under each title1 and title2 vary each day.
I would like to have the output as below:
1 abc. xyz. Name1 Id1 Qty1 Cust1 Diff1
2 abc. xyz. Name2 Id2 Qty2 Cust2 Diff2
3 abc. xyz. Name3 Id3 Qty3 Cust3 Diff3
4 pqr. def. Name4 Id4 Qty4 Cust4 Diff4
5 pqr. def. Name5 Id5 Qty5 Cust5 Diff5
that is I want the output to be nicely arranged in the columns with
the title1 and title2 info also captured in the columns as opposed to
as headers. Again the length of the report varies and also the number
of records within each title1 & title2.
Can someone please help me with a code to automate this task? Thanks
a
lot in advance for looking into this.
Regards,
ag

 

[AG]

Hi Guys,
I'll really appreciate any help on this. Thanks.

 

[Patrick Molloy]

what is the question?

 

[AG]

Hi Patrick,

The question is ... that I want to write a macro to make my data in an
excel report from the below:

title1: abc
title2: xyz
1 Name1 Id1 Qty1 Cust1 Diff1
2 Name2 Id2 Qty2 Cust2 Diff2
3 Name3 Id3 Qty3 Cust3 Diff3
...
...
title1: pqr
title2: def
1 Name4 Id4 Qty4 Cust4 Diff4
2 Name5 Id5 Qty5 Cust5 Diff5

To the output format -

1 abc. xyz. Name1 Id1 Qty1 Cust1 Diff1
2 abc. xyz. Name2 Id2 Qty2 Cust2 Diff2
3 abc. xyz. Name3 Id3 Qty3 Cust3 Diff3
4 pqr. def. Name4 Id4 Qty4 Cust4 Diff4
5 pqr. def. Name5 Id5 Qty5 Cust5 Diff5

That is, I need to bring the title1 and title2 values also as one
column as opposed to it being in the header. Also, note that the
number of records within each title vary on daily reports and also the
number of titles appearing on the report also vary.

Can you please help?