+ Reply to Thread
Results 1 to 1 of 1

How to Pivot and Unpivot any complicated columns data in Power Query

  1. 10-25-2016, 02:59 AM #1
    alipezu
    alipezu is offline
    Forum Contributor
    Join Date
    02-12-2014
    Location
    al ain
    MS-Off Ver
    Excel 2016
    Posts
    149

    Cool How to Pivot and Unpivot any complicated columns data in Power Query

    Hi All,
    I am new to Power Query and can unpivot simple columns but here the conditions are little complicated.
    Please help me pivot the above and unpivot the below data in the sheet.
    Please If possible, guide me the steps how to do it.
    Thanks.!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 editor - unpivot?
    By pccamara in forum Excel General
    Replies: 5
    Last Post: 09-07-2016, 10:26 AM
  2. Power Pivot help on creating calculated columns
    By Pavan.Sada.PS in forum Excel General
    Replies: 1
    Last Post: 08-21-2016, 05:36 PM
  3. Power Query, Pivot, View and Map
    By olasa in forum Suggestions for Improvement
    Replies: 4
    Last Post: 07-20-2016, 08:14 AM
  4. Power Query - Get external data from Folder
    By crainaud in forum Excel General
    Replies: 0
    Last Post: 03-24-2016, 12:49 PM
  5. How to remove null values from several columns with Power Query?
    By toblju in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2016, 11:08 AM
  6. Simple SQL Query in Power Pivot
    By zicitron in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-30-2014, 12:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1