+ Reply to Thread
Results 1 to 10 of 10

Transpose from columns to rows with Power Query

Hybrid View

lofgren Transpose from columns to... 06-20-2020, 03:52 AM
AliGW Re: Transpose from columns to... 06-20-2020, 04:01 AM
lofgren Re: Transpose from columns to... 06-20-2020, 04:15 AM
AliGW Re: Transpose from columns to... 06-20-2020, 04:55 AM
lofgren Re: Transpose from columns to... 06-20-2020, 03:16 PM
AliGW Re: Transpose from columns to... 06-20-2020, 04:22 PM
lofgren Re: Transpose from columns to... 06-20-2020, 05:09 PM
alansidman Re: Transpose from columns to... 06-20-2020, 11:32 PM
AliGW Re: Transpose from columns to... 06-21-2020, 12:24 AM
lofgren Re: Transpose from columns to... 06-21-2020, 10:56 AM
  1. #1
    Forum Contributor
    Join Date
    10-06-2017
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    123

    Re: Transpose from columns to rows with Power Query

    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:
    DataFormat.Error: We couldn't convert to Number.
    Details:
        659 Q
    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
    Last edited by lofgren; 06-20-2020 at 03:58 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  2. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  3. [SOLVED] Power Query - update particular columns
    By afgi in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 02-16-2020, 06:41 PM
  4. Add custom rows and columns in Power Query
    By Shao85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2019, 06:02 AM
  5. Custom Permutations Column in Power Query from two columns in the same Query
    By PaintPaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2019, 02:48 PM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. [SOLVED] Changing Power Query rows to columns on repeat cells.
    By beaglesBuddy in forum Excel General
    Replies: 3
    Last Post: 06-14-2017, 02:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1