Guide

1. Open your Power BI Desktop. Go to the 'Home' tab.

2. Click on 'Transform Data'.

3. Go to the column where you want to edit data and right-click on your mouse.

4. Use the dropdown in the column header to change data columns.

5. You can remove columns by clicking the 'Remove' option.

6. You can choose to remove duplicates or errors as you like.

7. You can make changes in the data code as well.

8. Once done, click 'Close & Apply' to save changes.