i’ve my data like this
now i need the data in the second column like
- i need read the two columns and in the the if condition row1 names to be found and if the match is found i need to write the data for that row in a different column
e.g., if row contains “policy_annual_premium:” then i need the data opposite to it which is “1328.26” be wrote in the different excel.
can anyone help me how can this be done