HI,
I have this list - XXXXXXXXXX
I want to reverse it in different modes -
1 : means keep signal
0 : means reverse
A reverse means X is converted into Y or Y is converted into X.
So if I had 1101101101 for XXXXXXXXXX,
The return is XXYXXYXXYX.
And if I had 1010101010 for XXXXXXXXXX,
The return is XYXYXYXYXY.
Can anyone show me how I program this rule in excel?
Bookmarks