VBA to change column to row and store the result in new column

[abraham30]

Hello Everyone!

In the attached sheet, I want to copy the result of columns G-J from sheet "Data" and store it in newly created column (Suppose "parameter") in sheet "Result" and its value in column "Value".

Same process should be done for col K-N from sheet "Data" and store the data in newly created col "VarCategory" and value in same column "Value".


Both rows and columns are present dynamically

Thanks in advance