Text to column and copy all data

[Pinang]

Hi,

Would anyone be able to help me separate column H and copy all data to another sheet?

Attached are the data and result sheets for reference.

 

[vletm]

Pinang​

Somewhere those pre-zeros are needed too...
Usage:
#1 Modify Data-sheet
#2 Select Result-sheet

 

[Pinang]

thank you so much. this is working.

 

[p45cal]

Right-click somewhere in the table on the Result sheet and choose Refresh (Power Query query).