Combing row 1 of column with another column

Hi all,

I am trying to combine my two columns into one. However combining row 1 of my column EIR Re-Calc with EIR Re-Calc and append it to the top of that column.

So just row 1 of EIR Re-Calc appending to the top of the left column.

Is this possible?

Custom Tools

Accepted answers

CarliE

Hi @wonka1234

This should get you there.

Workflow attached.

Combing row 1 of column with another column.yxmd

IraWatt

Is this what you are looking for @wonka1234 ?

Workflow0506.yxmd

H5-Brolin

Hi @wonka1234 please find attached.

Combing row 1 of column with another column.yxmd

All comments

IraWatt

Hey @wonka1234,

Is the idea to rename the first column with the data from the first row of the second column? Could you give the data in a format which can be copied?

H5-Brolin

Hi @wonka1234,

Are you trying append the data from the EIR Re-Calc row 1 into the column header of column 1 or what will essentially be 'row 0'?

Just so it's easier to understand what you're looking to achieve, it might be worth mocking up the end goal in Excel using the example in your screenshot and posting it here.