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?