I need help to fix excel format in 365

[ADUSMANI]

hello team,

i hava some export data i need your help about the formatting here is the sample how current data look like

i need one line data like material, short text, stock value but my stock value under the short text can you please help and moved into next col (stock value)

thanks

please advice 

[#2]

@ADUSMANI Perhaps with Power Query? See attached.

[#3]

THANKS@Riny_van_Eekelen 

[#4]

quick question after export the data into power query what step next please advice thanks

[#5]

@ADUSMANI You can look at the steps that I applied. Add a custom column that puts the stock value in its own column. Then fill-up end filter out rows that are null in the material column.

If you haven't worked with PQ before, the web-site in the link below would be a good place to start learning.

https://exceloffthegrid.com/power-query-introduction/