Hello,
Could you, please help me to generate a new row/line by taking into consideration the conditions below:
1. All the Code field, should have a sufix: "_1" if there is no other information into the columns "F-> K"
"_2" if there are info's into the columns "F-> K"
2. Add a new line, which keeps all the columns, but with some modifications:
One ACTIVE, from CODE column will be split by adding "_1" and "_2", as below:
* CODE columns with _1 will keep only values from A-> E, the rest will be blank
* CODE column with _2, will takeover the info from F->G, and at the "E" column, will add the amount from "H &K"
3. If no information will be available in the "F->K", add only the suffix "_1" to the ACTIVE code.
Please see the picture below for more clarity. Thank you!
Solved! Go to Solution.
Thanks a lot! :p