How to achive swapping columns

Question

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 DataExpected Result

Data Input.PNG

Expected Result.PNG

Greg_Murray · Accepted Answer

hi @sonal,

I think this is what you are looking for.

fmvizcaino · Accepted Answer

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