@NicoleJohnson I am struggling with parsing the data coming in excel . can someone please assist me with this?
I have a description column that i want to parse into 11 columns. but the order of data in each row will be different.
Description
2019 | AA Ltd | London | Completed | Factory | Jose | Phones | 4/3/2019 | 4/15/2019 | 4/15/2019 | 4
CC LTD | India | Pending | Industry | Sarah | Earphone | 3/5/2019 | 3/14/2019 | 3/14/2019 | 10.00
BB Ltd | 2019 | UK | Completed | Factory | Joseph | 4/3/2019 | 4/15/2019 | 4 |
Below is what i want the output to be in 3 rows.
Year Company Location Status Building Name Devices Receipt Date Start Date Delivered date Hours
2019 AA Ltd London Completed Factory Jose Phones 4/3/2019 4/15/2019 4/15/2019 4
null CC Ltd India Pending Industry Sarah Earphone 3/5/2019 3/14/2019 3/14/2019 10.00
2019 BB Ltd UK Completed Factory Joseph NULL 4/3/2019 4/15/2019 null 4
I can use text to column tool and split the data based on | pipe delimiter. But how to order those to tell it to go to year if its "2019" or Name if its "Jose"?
