Hi...
I am looking for a solution for my query. There is a process which I need to run from 1st to 10th of every month. I need the output data to be written one after another depends upon the empty column. For example
On Day 1, I get the below output.
Column A Column B Column C
Country Sell Profit
US XYZ XYZ
Japan XYZ XYZ
On Day 2, I need alteryx to paste the data from Column D (as this is empty at this point of time). So My output should be like previous day data (from col A to C) and today's data (from col D to F):-
Column A Column B Column C Column D Column E Column F
Country Sell Profit Country Sell Profit
US XYZ XYZ Aus XYZ XYZ
Japan XYZ XYZ NZ XYZ XYZ
India XYZ XYZ
On Day3, I need alteryx to paste the data from column G onwards as this is empty. Like this, I want all my data to be pasted one after another in empty columns.
