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 · Accepted solution]

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

Hope this helps

[Raj]

@AbhijeetChib As you are only looking to create a table with Number ID date and Name
the best option is to use filter tool to get all the IDs and Data associated with the table 
!isempty(ID) or !isempty(number) will give you the Rows and Select tool will help you to get columns
then at last using Output tool you can write data to new sheet.