Transform the Column Data

[Chanleakna123]

HI All , 

Great day to you. 

*Refer to 1st picture , i have never want to change the format of the file since the file has been used by many people. so i wanna keep it the same. and i'm thinking to import this into Power BI , Do i have any chance to move ETA CBC : 21 Feb , 28 Feb , etc... to below row next to Materials ??????? 

*Refer to 2nd Picture , same as above question , do i have any chance to move loading next to QU/Shift replace Firm ????? 

your response is really help me a lots. 

Best Regards, 
Chanleakna Hang 

[v-qiuyu-msft]

Hi @Chanleakna123,

Not sure how source table looks like. It would be better if you could share some sample data and clarify the desire results. Do you want to get that format in visuals or data model? 

Best Regards,
Qiuyun Yu