Transformation of Multicolumns

[KarthickDijo]

Hi All,

How can the 8 columns be transferred to two columns as shown in the attachment. XL2BB isn't working on my side, so attaching in image format.

Thanks in advance !!

 

[ouvay]

Just curious, why did you choose PQ over VBA?

 

[Fluff]

Just curious, why did you choose PQ over VBA?

Maybe because the question is in the Power Tools section.

 

[Automatrix]

Just curious, why did you choose PQ over VBA?

PQ is much more user friendly, and can even be taught to "normal people".

 

[Fluff]

PQ is much more user friendly

In your opinion maybe, but not everyone would agree.

can even be taught to "normal people".

Are you trying to say that people who write & understand VBA are not normal?

 

[ouvay]

Maybe because the question is in the Power Tools section.

Ohhh!! You're right! I hadn't noticed!!

 

[ouvay]

PQ is much more user friendly, and can even be taught to "normal people".

Agree to disagree, VBA is a lot more readable due to its similarities to other programming languages.. even my initial exposure to VBA, I could read and understand it to some degree(knowing other languages)
the accepted answer to this question however is going over my head

 

[Automatrix]

Agree to disagree, VBA is a lot more readable due to its similarities to other programming languages.. even my initial exposure to VBA, I could read and understand it to some degree(knowing other languages)
the accepted answer to this question however is going over my head

"Normal people" don't know any other programming languages. To them, PQ is more intuitive. The Add Column action is a good example of how you can do programming in a way that's not too abstract.

 

[Automatrix]

In your opinion maybe, but not everyone would agree.

Are you trying to say that people who write & understand VBA are not normal?

Not in a statistical sense. How many % of employees in an average organisation can write and understand VBA?

 

[Fluff]

"Normal people" don't know any other programming languages.

Then what do you think M-code is, if it's not a programming language?

 

[Automatrix]

Then what do you think M-code is, if it's not a programming language?

It certainly is, but you can do many things in PQ without having to write any M code.