+ Reply to Thread
Results 1 to 1 of 1

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

  1. #1
    Forum Contributor
    Join Date
    02-12-2014
    Location
    al ain
    MS-Off Ver
    Excel 2007
    Posts
    143

    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 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 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1