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.
Solved! Go to Solution.
I would filter on number for not empty !isempty([number]) and then use the select tool to remove unwanted columns.
Hope this helps
@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.