Dear All,
I wonder if anybody can help. We are getting a pretty difficult output from one of our surveys.
It looks like this:
<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 :
<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.
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.