Results 1 to 10 of 10

Transpose from columns to rows with Power Query

Threaded 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

    Transpose from columns to rows with Power Query

    Hello all,

    I am real beginner in Power Query, knowing to do just basic stuffs... But right now i am in front of a problem where i think i can use Power Query, but i am blocked

    So i have the attached table and since in the end i will have to print a sheet with today values, i think that the "easiest" solution would be transpose in power query. But it seems harder than i believed in the first place.

    On the attached table, sheet "from" contains the table i have right now and sheet "to" contains the dates that i need to be exported by power query. I tried to user transpose with unpivot columns... but the result was a total mess

    In the end i will use a formula to get the dates from today, for all parts and print it.

    Do you think this can be done? Should i use another solution? Any help is highly appreciated.

    Thank you for your time
    Attached Files Attached Files

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