Hi,
I have not been able to solve. I need a formula that will convert a column of data into a new column of data minus some repeat lines of garbage text. There are three distinct TextStrings and each repeats after 3 rows and occasionally there is a line or two of garbage.
Example data is in Column H and Result I want is in Column I but I am not sure how to get there.
<tbody>
</tbody>
Thanks
I have not been able to solve. I need a formula that will convert a column of data into a new column of data minus some repeat lines of garbage text. There are three distinct TextStrings and each repeats after 3 rows and occasionally there is a line or two of garbage.
Example data is in Column H and Result I want is in Column I but I am not sure how to get there.
COLUMN H | COLUMN I | |
1 | TextString1 | TextString1 |
2 | TextString2 | TextString2 |
3 | TextString3 | TextString3 |
4 | TextString1 | TextString1 |
5 | TextString2 | TextString2 |
6 | TextString3 | TextString3 |
7 | TextString1 | TextString1 |
8 | TextString2 | TextString2 |
9 | TextString3 | TextString3 |
10 | GarbageLine1 | TextString1 |
11 | GarbageLine2 | TextString2 |
12 | TextString1 | TextString3 |
13 | TextString2 | |
14 | TextString3 |
<tbody>
</tbody>
Thanks