Transpose from columns to rows with Power Query

Use this M Code:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Dear Ali,

In my original table i have a lot of different names as headers, for example 088888 659 Q.
When i try to adapt your code into my original table i am getting the following error:

Please Login or Register  to view this content.

If i remove that column, i am getting the same error for another column, for example 075426 123 M

Any ideea why is this happening?

EDIT1:
I tried to change Int64.Type to Text.Type, just for fun...
I don't have any error now, but it only imports 92 row, instead of 177...

EDIT2:
i just realized that part of my table is not finished yet, so it contains no data yet. So i replace null with 0 in PQ and now i think that it imports all rows.
I must see how can i change the code, in order to not sort column a from smallest to greatest.

When you have time, please let me know if the changes i made are ok or are just silly

I can’t say without seeing more realistic data in a sample.

You have the Attribute Column as a Type Whole Number. It can't be and therefore you are getting a sort error. The column needs to be type "Text"

Here is the revised Mcode making that column Text.

Please Login or Register  to view this content.

@Ali--Great piece of manipulation. Loved how you got it to sort by duplicating the column and removing the first character.

Thanks, Alan.