Combing row 1 of column with another column

[wonka1234]

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?

[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? 

[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.

Thanks!

[CarliE]

@wonka1234 

Is this what you're looking for?

I added a record ID and then transposed the data.

If so, please make sure to mark this as a solution to help other members on the community out!

Best

[wonka1234]

Hi all,

I want 1 column as the output. 

Take the value from EIR Re-Calc (-46757187.19) and Insert it into row one of EIR Re Calc.

So output like

EIR Re Calc

-46757187.19

1085437

1070875

etc

[brolin]

Hi @wonka1234 , you will need to add a RecordID tool and then use the Formula tool for an IF statement with the following:

if [RecordID] = 1 then [EIR Re-Calc] else [EIR Re Calc] endif

I've created an example here for you:

Hope this helps! I can share the workflow file if you'd like too.

[wonka1234]

@brolin Would you share your workbook? 

the problem with this is that it seems to overwrite the first row of EIR Re Calc or 1085437

[CarliE · Accepted solution]

Hi @wonka1234 

This should get you there.

Workflow attached.

[IraWatt · Accepted solution]

Is this what you are looking for @wonka1234 ?

[brolin · Accepted solution]

Hi @wonka1234 please find attached.