Shift Data Right

nicktagz · December 30, 2021, 1:27pm

Is there a function to shift data right? I see there's one to shift data up/down.

dgudkov · December 30, 2021, 1:39pm

Can you provide an example of what it should do?

nicktagz · December 30, 2021, 1:46pm

In this example, I'd like to shift all the values from left to right so that the first column is empty.

dgudkov · December 30, 2021, 1:47pm

How about just renaming columns?

nicktagz · December 30, 2021, 1:48pm

I could do that, however sometimes there are up to 20 columns or more. I was just looking for an easier way.

dgudkov · December 30, 2021, 1:51pm

You can use the "Rename columns with lookup" action. Produce a list of column names using the "Table metadata" action, then shift it down to obtain the name lookup table.

I don't think there is an easier way. This one is not hard though.

nicktagz · December 30, 2021, 1:57pm

That can work, thank you!