Select data depending upon column name stored in a row

[sbatra116]

Hello everyone, 

Need helpw with below scenario.

scenario:  

Below is the sample table. generic headers

column4 (last column) sotres the header value of other columns. i need to replace data in column4 with the actual row value.

ID	Column1	Column2	Column3	Column4
1	Test1	1234	sometextvalue	Column1
2	Test2	6544	sometext	Column3
3	Test3	3445765	dummytext	Column2
4	Test4	4564556	dummy	Column1

final data should look something like this 

ID	Column1	Column2	Column3	Column4
1	Test1	1234	sometextvalue	Test1
2	Test2	6544	sometext	sometext
3	Test3	3445765	dummytext	3445765
4	Test4	4564556	dummy	Test4

[AkimasaKajitani · Accepted solution]

Hi @sbatra116 

By creating a header/value correspondence table for Columns 1 through 3, we can combine the Column4 value and the another header.

To do so, you need to use Transpose Tool. Then you use JoinTool to join them together.

The workflow is as follows.