I need help to fix excel format in 365

Question

hello team,i hava some export data i need your help about the formatting here is the sample how current data look likei 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&nbsp;please advice&nbsp;

riny_van_eekelen · Answer

ADUSMANI&nbsp;Perhaps with Power Query? See attached.

adusmani · Answer

THANKSRiny_van_Eekelen&nbsp;

adusmani · Answer

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

riny_van_eekelen · Answer

ADUSMANI&nbsp;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.&nbsp;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/&nbsp;

Forum Discussion

I need help to fix excel format in 365

Resources