How to achive swapping columns

[sonal]

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

[Greg_Murray · Accepted solution]

hi @sonal,

I think this is what you are looking for.

[fmvizcaino · Accepted 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

[sonal]

Thank you It worked like a charm.