Taking over column from a table into another table dynamically

[tferenc80]

Hello All! I have a problem that I cannot solve.

So I have table 1 with columns of which headers are calendar week numbers. So 41, 42, 43, etc. This comes from a sharepoint xsl file and will have further columns as the time goes.

Now I have another table where I want to have the same data but with a defined delay, which can be changed. So I say that the delay is now =2, and then column 42 from table 1 should appear in table 2 as column 44.

Can anyone recommend a solution for this?

[Anonymous]

Hi @tferenc80 ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @tferenc80 ,

Your requirement may not reach currently... All I could do is select columns and rename them like this:

Table =
SELECTCOLUMNS ( 'Table1', "44", [42], "45", [43] )

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin