In one sheet, I have an raw data like this:
<tbody>
</tbody>
And on another sheet, I need to use the raw data above to make something like below:
<tbody>
</tbody>
so from one record in raw data sheet and generate 2-row record in another sheet for about 100-150 records like that.
Please help! Thank you very much for your time and wisdom.
Invoice Number | Date | Amount | ||||||
1st |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
2nd |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
And on another sheet, I need to use the raw data above to make something like below:
H | USD | 2000 | copy 1st invoice number here | IN | copy 1st invoice datehere | copy 1st invoice amount here |
T | 1022510000 | copy 1st invoice amount here | N | |||
H | USD | 2000 | copy 2nd invoice number here | IN | copy 2nd invoice date here | copy 2nd invoice amount here |
T | 1022510000 | copy 2nd invoice amount here | N |
<tbody>
</tbody>
so from one record in raw data sheet and generate 2-row record in another sheet for about 100-150 records like that.
Please help! Thank you very much for your time and wisdom.