Transpose multiple columns into one column

[alferd324]

How to transpose from column G to column K in table of sheet1 into column A only in sheet 2? At the same times skip the blank cell when transpose

[alansidman]

With Power Query, here is your transposition Mcode.

Please Login or Register  to view this content.

[alferd324]

Sorry i don't know how to insert the code. I am just a beginner of Power Query. Can you teach me?

[jindon]

VBA

Please Login or Register  to view this content.

[alansidman]

Suggest you pick up the book, "M is for (Data) Monkey" by Ken Puls and Miguel Escobar.

In the interim, open a blank PQ and then click on View -->Advanced and replace the code in the viewer with mine.

[alferd324]

Thank you for your reply. Can you teach me how to implement the VBA into worksheet?

VBA

Please Login or Register  to view this content.

[jindon]

There was a typo and fixed original post #4

[alferd324]

Thanks for your help