Get output in specific columns by skipping some columns

[Rahul_Analyst]

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. 

[JarekSkudrzyk · Accepted solution]

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

[Rahul_Analyst]

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

[JarekSkudrzyk]

@Rahul_Analyst great to hear that:)