Hello,
I search the forum for something familiar but I cannot find any. Please help me out. Example column H, row 3-10 have data which includes blank. What I want to do is whatever data entered in column I get extracted to column T without the blank. Copy and paste are tedious for hundreds of pages.
Thank you very much in advance.
<tbody>
</tbody>
I search the forum for something familiar but I cannot find any. Please help me out. Example column H, row 3-10 have data which includes blank. What I want to do is whatever data entered in column I get extracted to column T without the blank. Copy and paste are tedious for hundreds of pages.
Thank you very much in advance.
a | A | D | E | F | G | H | I | J | K | L | S | T | U | V | W | ||||
123 | |||||||||||||||||||
2 | 145 | ||||||||||||||||||
3 | 123 | abc | |||||||||||||||||
4 | 145 | def | |||||||||||||||||
5 | 789 | ||||||||||||||||||
6 | abc | 900 | |||||||||||||||||
7 | def | ||||||||||||||||||
8 | |||||||||||||||||||
9 | 789 | ||||||||||||||||||
10 | 900 | ||||||||||||||||||
<tbody>
</tbody>
Last edited: