Hi,
I am working with a dataset where I need to swap the 'value' of 'Attribute Label' field with 'Attribute Value' field. I have marked to color red to signify the swap.
Please note that value of each attribute label changes with each product. So, Value of Attribute Label1: Type should be swapped with Name Attribute Value1.
Input Data and Expected result is attached. Please guide me how to achieve this.
Input Data
Expected Result
Solved! Go to Solution.
Hi @sonal ,
I've used regex to separate your label name into header and line number and used a cross-tab to achieve what you are looking for. Take a look!
Best,
Fernando Vizcaino
Thank you It worked like a charm.