Get output in specific columns by skipping some columns

Hi,

I want to output my data at specific range. I know Alteryx can do like this A2:C10. But in this case, it is taking Col A, B, and C, all three columns. Is it possible, I want output in Col A and Col C, not in Col B. Means, I can set my range as per specific columns, where I want data like -Col A, Col C, Col E and I can keep my columns Col B, Col D empty (not overwrite).

Actually, I do not want to overwrite in Col B and Col D, because it contains formula. And, if I overwrite it then it will be deleted.

Workflow

Output

Accepted answers

@Rahul_Analyst have you tried splitting the output data into 3 and then outputting it via separate output tools to the .xlsx file?

New Workflow5.yxzp

All comments

@Rahul_Analyst have you tried splitting the output data into 3 and then outputting it via separate output tools to the .xlsx file?

New Workflow5.yxzp

@JarekSkudrzyk , amazing! it worked really well. This is what I wanted.

@Rahul_Analyst great to hear that:)

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703