division into even and odd

[mrslyfox]

Dear Colleagues,

Looking for ideas how to create calculated columns which can represent results in the folowing way

Date	Customer	Product	Product ID	Customer Order Nr	Number of Carriers	Calculated Column
02-03-18	Customer A	Product A	10001	20001	1	1
02-03-18	Customer A	Product A	10001	20001	1	0
02-03-18	Customer A	Product A	10001	20001	1	1
02-03-18	Customer A	Product A	10001	20001	1	0
02-03-18	Customer A	Product A	10001	20001	1	1
02-03-18	Customer A	Product A	10001	20001	1	0
03-03-18	Customer B	Product B	10002	20002	1	1
03-03-18	Customer B	Product B	10002	20002	1	0
03-03-18	Customer B	Product B	10002	20002	1	1
03-03-18	Customer B	Product B	10002	20002	1	0

[Lind25 · Accepted solution]

You can do this using Power Query Editor.
Add an index column starting at 1. Then transform this using standard > modulo with a divisor of 2.