Transposing unknown number of sets of 7 columns into rows

[damballa]

Dear All,

I wonder if anybody can help. We are getting a pretty difficult output from one of our surveys.
It looks like this:

No	Detail	ON	OFF	T	Pay	P	D	Comment	ON	OFF	T	Pay	P	D	Comment
1	12345	1	7	12	0	1	0		5	12	16	0.50	1	0
2	12346	2	8	10	0	2	0		7	11	20	0	1	1

<tbody>
</tbody>

Problem we have is that the columns can go on to a different depth in each line entry. So line 1 could have 49 columns and line 2 could have 70 columns Ideally we would like the output to be like this :

NO	Detail	ON	OFF	T	Pay	P	D	Comment
1	12345	1	7	12	0	1	0
2	12345	5	12	16	0.50	1	0
3	12346	2	8	10	0	2	0
4	12346	7	11	20	0	1	1

<tbody>
</tbody>

So I would like to transpond every 7 columns into rows. I have done so but only per each line and I had to find out where it ends as well as insert more lines (yes I am not great with formulas I am afraid). I was wondering if any of you would know about a better and smarter way of doing this.

Thank you.