Cleaning Data in Power BI

I have data in typically cells A1 and A2 which I need to enter into say cells B1 and C1. This needs to be done for 10,000 + rows.

Any suggetions please?

HI there. Are you still looking for help with this?

It sounds like you should just be able to copy the columns in the data view or in transform. If you post an image or a link to the .pbix file I might be able to help more. :slight_smile:

Hi. Thanks for response. I have ended up copying the data from the transform window to Excel as I had some time constraints. If the client is happy with the BA report (pro-bono), I will be given other wards to deal with. I will then reach out again.