Forum Discussion

npatten's avatar
npatten
Helper II
6 years ago
Solved

summarize data by cell values

Hi--   Trying to solve a summarization problem. I'm working with survey data for a client. Currently the data output is structed with questions as the column headers, and the cell values (converted...
  • calerof's avatar
    6 years ago

    Hi npatten,

     

    It is indeed a Power Query transformation with Unpivot. See:

     

    Unpivot all columnsShow in a matrix with Count

    Hope it helps.

    Regards,

    Fernando