Hi All,
I am newbie. I want to copy first row of Excel sheet to be inserted before every cell that satisfies condition.
For example:
Header1 Header2 Header3
1 cell2 cell3
2 cell4 cell5
1 cell6 cell7
Expecting ouput:
Header1 Header2 Header3
1 cell2 cell3
2 cell4 cell5
Header1 Header2 Header3
1 cell6 cell7
In above ouput i want to insert header if value of first column is 1.
Thanks in advance.
I am newbie. I want to copy first row of Excel sheet to be inserted before every cell that satisfies condition.
For example:
Header1 Header2 Header3
1 cell2 cell3
2 cell4 cell5
1 cell6 cell7
Expecting ouput:
Header1 Header2 Header3
1 cell2 cell3
2 cell4 cell5
Header1 Header2 Header3
1 cell6 cell7
In above ouput i want to insert header if value of first column is 1.
Thanks in advance.