Field name in the same column

[P_S]

Hello, I need help with changing data structure. As in the image

The dimension of this field name as "Name" and it has 4 attributes as "A, B, C, D" I would like to change A, B, C, D as a fields (dimension). How can I do it? I try "Unpivot"but it split this field into 2 fields as "Event" that contain all attribute as 'Name' in it and "Event" that contain 'A, B, C, D' in it.

[alextimofeyev]

What values do you expect to have in the fields A, B, C and D?

[Anil_Babu_Samineni · Accepted solution]

If you are working using "Data Manager" There you can use "Unpivot" concept. If you are using Data Model viewer - Use, Generic Load concept Or Use Cross Table concept