multi-value

  1. L

    Power Query: Removing duplicate values in Multi-Value Cells

    Hi there. Long-time Excel user and dabbler in VBA and Power Query. I've got a variation on a problem I posted a few years ago in this thread. There, folks helped me use PowerQuery to collapse data, combining multiple rows into single, multi-value cells while removing duplicates. The wrinkle...
    • lneidorf
    • Thread
    • dedupe multi-value power query sort
    • Replies: 6
    • Forum: Power Tools
  2. E

    Convert a single row with multiple columns (each column has multiple data elements) to multiple rows with the same A column value

    Building on the discussion here - http://www.mrexcel.com/forum/excel-questions/707997-convert-single-row-multiple-rows-same-column-value.html I have a data set with a unique key in Column A and then repeating values in the subsequent columns. I would like to transform the repeating values into...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top