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?