locked
Power Query : how to do pivot on dimension column RRS feed

  • Question

  • Power Query : how to do pivot on dimension column 
    Friday, May 8, 2015 5:21 PM

Answers

  • Hi there. Have you looked into the Pivot operation?

    http://excelunplugged.com/2014/09/30/the-pivot-option-in-power-query/

    Let us know if that's not what you were looking for.

    Thanks,

    Ehren

    • Proposed as answer by Michael Amadi Wednesday, May 13, 2015 8:31 PM
    • Marked as answer by Michael Amadi Friday, May 29, 2015 11:47 AM
    Monday, May 11, 2015 5:42 PM
  • Hi,

    I need some more information, e.g. a pre-pivot table layout including example records and a post-pivot table layout including example records.

    Have a look at the following link; - Pivoting Data In Power Query

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/


    Tuesday, May 12, 2015 8:23 PM

All replies

  • Hi there. Have you looked into the Pivot operation?

    http://excelunplugged.com/2014/09/30/the-pivot-option-in-power-query/

    Let us know if that's not what you were looking for.

    Thanks,

    Ehren

    • Proposed as answer by Michael Amadi Wednesday, May 13, 2015 8:31 PM
    • Marked as answer by Michael Amadi Friday, May 29, 2015 11:47 AM
    Monday, May 11, 2015 5:42 PM
  • Hi,

    I need some more information, e.g. a pre-pivot table layout including example records and a post-pivot table layout including example records.

    Have a look at the following link; - Pivoting Data In Power Query

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/


    Tuesday, May 12, 2015 8:23 PM