Dynamic column append and maintain data source order

royceton10

Hello,

My query is related to dynamic column append every month maintaining the data source order.

I have 1,2,3 sources of data, and I have to transpose the data from the source 2 and source 3 into the current day column for the current date, and the average of the previous months data(at month end) with the current month columns being first in order for that specific data source in the decreasing order of the month columns for each month back to Jan 2020. Not sure how to do this dynamically each month.

I have attached an sample sheet. March is what I currently have, and April is the desired output (in green)  and so on.

Any help would be appreciated.

Thanks,

dynamic column ordering.xlsx

OllieClarke

Hi @royceton10 

Here's a way of dynamically generating the headers in the correct order. I've made this workflow for one data source, but you can just copy the process (possibly amending the formula tool that makes the headers) for the other sources.

Hope that helps,

Ollie

dynamic columns.yxmd