i need help on cleaning this data. Currently I’ve no idea to clean this kind of data. I want to clean based on month and total per supplier. Thanks
>Solution :
- Select the first 2 columns [No] and [Supplier]
- On the tab
Transformdrop downUnpivot Columnsand click onUnpipot Other Columns
This converts your wide pivot table into a long, stacked format that is ideal for further processing.

