I am trying to get the correct values from an Excel sheet on the basis of label.
For example, If I have an excel sheet as follows:
Name: ABCD Age: 23
Address: XYZ Co.
and so on.
What would be the best approach to implement to get the right result?
Although the label and value will be together, their collective position may change. For example, we can have Address at the top and Name at the right and so on.
One way would be to use Output data table and apply logic such as split/substring etc. but I think that can cause issues.
Please suggest and alternative techniques if you have implemented such a scenario.