Find a way to pivot columns in a pattern to pivot columns conditionally?

[brickanalyst]

Hello guys,

my question is a bit confusing for a moment, so I asked for ideas.

think about two columns and we have all the attributes and values. 
I want 6 columns so pattern is ending with _1 _2 _3 _4 _5 _6 so that I will have 6 different columns 
or I just want to pivot these 6 columns out of possibly 10

Is it possible? 

[brickanalyst · Accepted solution]

I have found the answer:

split by delimeter _ 
so it's going to be S_M_2 and 1 etc.

then take the splitted column which values are 1,2,3,4,5,6 and pivot to the respected values.

there you go.