How to extract value in row and add as a column

Hi Guys

I have a question on how to convert this table below

GL-Upper Row Value
RC-Second Row Value

GL/RC GL Acc Desc Product Amount
1201100000 Auto(PDO NA)-Asset Prin-SGD 0.00
0100401884
1201100000 Auto(PDO NA)-Asset Prin-SGD 0.00
0100401884
1201100000 Auto(PDO NA)-Asset Prin-SGD 0.00
0100401884
1201100000 Auto(PDO NA)-Asset Prin-SGD 0.00
0100401884
![image 478x181](upload://jjqlffsyC2BiBZ2ZuFPeFvUkqgr.png)

Into this table, I want the second row to put in new column and level with GL Row

Sample Output Data
GL GL Acc Desc Product Amount RC
1201100000 Auto(PDO NA)-Asset Prin-SGD 0.00 0100401884
1201100000 Auto(PDO NA)-Asset Prin-SGD 0.00 0100401884
1201100000 Auto(PDO NA)-Asset Prin-SGD 0.00 0100401884
1201100000 Auto(PDO NA)-Asset Prin-SGD 0.00 0100401884
![image 472x121](upload://4y7eFYG8eLuwsbLtBtbmXz7jAoJ.png)

Thank you!

Hi @seanmanzanilla

Please find below a possible solution:

20220209 Pikairos How to extract value in row and add as a column.knwf (37.1 KB)

Hope it helps.

Best

Ael

2 Likes

Hi @aworker

Yes, I already solved the problem on my own but it takes a lot of nodes. But I think you have a better approached, will reconsider this one on my process, thank you and god bless!

1 Like

Hi @seanmanzanilla

Thanks for your so kind message and for validating/adopting the solution :smiley:

All my best wishes,

Ael

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.