Well, if that is the case, instead of using a For each loop, use a normal Loop action, and iterate from 2 to %ExcelData.RowsCount%. And iterate by 2.
It should look somewhat like this:
You'll get a %LoopIndex% variable that you don't actually need to increment, because the Loop action will increment it for you. And then simply use that when writing your values.
You can drop the If condition inside the loop, because it makes no sense to have it anyway. It will never be empty, because you're effectively checking for a data row to be empty. That can't happen, even if the cells are blank. But also, since you are alternating the rows, it doesn't make sense to do the check.
So, simply use a Loop and write all of those formulas the same way you're doing right now, but instead of the two indexes you're using, just use %LoopIndex%.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
