relational column processing using awk sed File 1 ---> Scrambled data in column (Old stale files with intermediate test data)

mL9A7hajHyuVIQr1HNP7ThYfj9yBUd Iq4iqnH4UftLgGUSobLeti0hkmdMn7 BlzanDNcIsgru2wNYlO6kDjpuPvs82 eqOZRXfdcxHqd26Raqd6ZOtPhoQp33 CrWSI2eyZZkkYlEbOoHgu2o43tU3xa IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7 YuuRhD5f3xju0RnUCjS66g3X2TNNIj MpJHtG8FjeErwsh6emcCu7B4bHwCnR aQ1DXaG7XSopgxBeBsRRZcCh2xRu5f nXgwlL0p8LEWNFGznIy2NUXBWHzZgS 

File 2---> Same data but in final order (New files after yearly audit and changing intermediate data to final form after test )

BlzanDNcIsgru2wNYlO6kDjpuPvs82 CrWSI2eyZZkkYlEbOoHgu2o43tU3xa IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7 Iq4iqnH4UftLgGUSobLeti0hkmdMn7 MpJHtG8FjeErwsh6emcCu7B4bHwCnR YuuRhD5f3xju0RnUCjS66g3X2TNNIj aQ1DXaG7XSopgxBeBsRRZcCh2xRu5f eqOZRXfdcxHqd26Raqd6ZOtPhoQp33 mL9A7hajHyuVIQr1HNP7ThYfj9yBUd nXgwlL0p8LEWNFGznIy2NUXBWHzZgS 

Trying to explain problem From now on whatever processing we do on Final_results file we wanted to reflect the same change in intermediate test files preserving their order

paste <(cat temp_data | nl) <(cat Final_results) | column

1 CrWSI2eyZZkkYlEbOoHgu2o43tU3xa 3 BlzanDNcIsgru2wNYlO6kDjpuPvs82 2 BlzanDNcIsgru2wNYlO6kDjpuPvs82 5 CrWSI2eyZZkkYlEbOoHgu2o43tU3xa 3 IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7 6 IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7 4 Iq4iqnH4UftLgGUSobLeti0hkmdMn7 2 Iq4iqnH4UftLgGUSobLeti0hkmdMn7 5 aQ1DXaG7XSopgxBeBsRRZcCh2xRu5f 8 MpJHtG8FjeErwsh6emcCu7B4bHwCnR 6 YuuRhD5f3xju0RnUCjS66g3X2TNNIj 7 YuuRhD5f3xju0RnUCjS66g3X2TNNIj 7 MpJHtG8FjeErwsh6emcCu7B4bHwCnR 9 aQ1DXaG7XSopgxBeBsRRZcCh2xRu5f 8 eqOZRXfdcxHqd26Raqd6ZOtPhoQp33 4 eqOZRXfdcxHqd26Raqd6ZOtPhoQp33 9 mL9A7hajHyuVIQr1HNP7ThYfj9yBUd 1 mL9A7hajHyuVIQr1HNP7ThYfj9yBUd 10 nXgwlL0p8LEWNFGznIy2NUXBWHzZgS 10 nXgwlL0p8LEWNFGznIy2NUXBWHzZgS 

Desired relational processing. If i change 3 BlzanDNcIsgru2wNYlO6kDjpuPvs82--SUFFIX ----> File2 (Column 2 in above commands) Then reflect the change 6 IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7-SUFFIX --->File1 (Column1 in above commands)

Eg. What was IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7 before testing was now BlzanDNcIsgru2wNYlO6kDjpuPvs82 in Fina_results. So now whatever processsin we do on BlzanDNcIsgru2wNYlO6kDjpuPvs82 in Final should reflect on IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7 in previous files

PROBLEM1 Desired Output 1

1 CrWSI2eyZZkkYlEbOoHgu2o43tU3xa 3 BlzanDNcIsgru2wNYlO6kDjpuPvs82--SUFFIX 2 BlzanDNcIsgru2wNYlO6kDjpuPvs82 5 CrWSI2eyZZkkYlEbOoHgu2o43tU3xa 3 IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7-SUFFIX 6 IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7 4 Iq4iqnH4UftLgGUSobLeti0hkmdMn7 2 Iq4iqnH4UftLgGUSobLeti0hkmdMn7 5 aQ1DXaG7XSopgxBeBsRRZcCh2xRu5f 8 MpJHtG8FjeErwsh6emcCu7B4bHwCnR 6 YuuRhD5f3xju0RnUCjS66g3X2TNNIj 7 YuuRhD5f3xju0RnUCjS66g3X2TNNIj 7 MpJHtG8FjeErwsh6emcCu7B4bHwCnR 9 aQ1DXaG7XSopgxBeBsRRZcCh2xRu5f 8 eqOZRXfdcxHqd26Raqd6ZOtPhoQp33 4 eqOZRXfdcxHqd26Raqd6ZOtPhoQp33 9 mL9A7hajHyuVIQr1HNP7ThYfj9yBUd 1 mL9A7hajHyuVIQr1HNP7ThYfj9yBUd 10 nXgwlL0p8LEWNFGznIy2NUXBWHzZgS 10 nXgwlL0p8LEWNFGznIy2NUXBWHzZgS 

PROBLEM2 Desired Output 2 Transpose second file to first.

See in paste command output 3 BlzanDNcIsgru2wNYlO6kDjpuPvs82--SUFFIX has 3. So in first colum 3rd row needs to be changed with first row of column 4 which has 3 in third column and likewise entire output transposr columns and finally output changed data

1 mL9A7hajHyuVIQr1HNP7ThYfj9yBUd-Suffix 2 Iq4iqnH4UftLgGUSobLeti0hkmdMn7-Suffix BlzanDNcIsgru2wNYlO6kDjpuPvs82-Suffix 4 eqOZRXfdcxHqd26Raqd6ZOtPhoQp33-Suffix 5 CrWSI2eyZZkkYlEbOoHgu2o43tU3xa-Suffix 6 IUnZ8VPgw0FuqJmsY6FYfUpMdDNnk7-Suffix 7 YuuRhD5f3xju0RnUCjS66g3X2TNNIj-Suffix 8 MpJHtG8FjeErwsh6emcCu7B4bHwCnR-Suffix 9 aQ1DXaG7XSopgxBeBsRRZcCh2xRu5f-Suffix 10 nXgwlL0p8LEWNFGznIy2NUXBWHzZgS-Suffix 

##Simplified data (for testing solutions)

1 Mina_Warren 2 Ayden_Silva 2 Jazlene_Gibbs 4 Quintin_Glover 3 Kaleigh_Farley 1 Callum_Mckay 4 Callum_Mckay 7 Jazlene_Gibbs 5 Finn_Nelson 6 Mina_Warren 6 Ayden_Silva 3 Kaleigh_Farley 7 Quintin_Glover 5 Finn_Nelson 

Output (ONLY FOR PROBLEM 1)

1 Mina_Warren--Suffix3 2 Ayden_Silva---Suffix1 2 Jazlene_Gibbs--Suffix1 4 Quintin_Glover--Suffix2 3 Kaleigh_Farley--Suffix6 1 Callum_Mckay--Suffix3 4 Callum_Mckay--Suffix2 7 Jazlene_Gibbs-Suffix4 5 Finn_Nelson--Suffix7 6 Mina_Warren--Suffix5 6 Ayden_Silva--Suffix5 3 Kaleigh_Farley--Suffix6 7 Quintin_Glover--Suffix4 5 Finn_Nelson-Suffix7 

(ONLY FOR PROBLEM 1) Here Suffix --- Means ---> Any kind of processing editing renaming replacing etc. Any Processing in 4th column of certain line will reflect same on 2nd column of nth line. ---> Here nth line is obtained by third column

Logic for Problem 1 for awk --Read first record. --Store column $4 in variable and --then goto line number as shown in column3 $3 --then replce column $2 with varible stored from $4

Consider

1 Mina_Warren 2 Ayden_Silva 2 Jazlene_Gibbs 4 Quintin_Glover 

Third columns are linenumber for relational edit. Logic for problem 1 Read row 1 ---> Store Ayde _Silva in variable ---> Goto row 2 because of 2 in $3 of row 1 ---> Now on row 2 have same prcessing on Jazlene_Gibbs

Desired Output Problem 1

Mina_Warren 2 Ayden_Silva--Suffix1 2 Jazlene_Gibbs--Suffix1 4 Quintin_Glover 

Logic for problem 2 Transposing Read row 1 ---> Store Ayde _Silva in variable ---> Goto row 2 because of 2 in $3 of row 1 ---> Now on row 2 replace Jazlene_Gibbs with processed version of Ayde_Silve ---> Do these for all lines in loop ---> Delete column 3 and column 4

Desired output Problem 2

1 Callum_Mckay--Suffix3 2 Ayden_Silva--Suffix1 3 Kaleigh_Farley--Suffix6 4 Quintin_Glover--Suffix2 5 Finn_Nelson--Suffix7 6 Mina_Warren--Suffix5 7 Jazlene_Gibbs--Suffix4 

Tried

awk -v ty=$in '{for (i=1;i<=ty;i++) NR==$i; var=$4; varb=$3; NR == varb; $2=var; print}' 

but not working as intended logic