I need help to fix excel format in 365

Copper Contributor

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)



please advice 

4 Replies

@ADUSMANI Perhaps with Power Query? See attached.

Screenshot 2023-02-04 at 21.10.50.png

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

@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.