Sorting jumbled data

AbhijeetChib

Hello Everyone 

I have jumbled data in the below format and I need to collect certain field information to the next sheet. I need to read Number, ID name and Date and paste it in a separate sheet. 

For example, the new sheet will be 

Number ID             Name    Date 

30060    1001751   Sigma   01.01.2023

300601  1001751   Sigma   02.01.2024

Thanks. 

aatalai

I would filter on number for not empty !isempty([number]) and then use the select tool to remove unwanted columns.

Hope this helps