hello-looking to see if there is a solution to this problem. i have a data set that i have parsed and it has created 30 additional columns. the data is scattered within the columns -with no specific pattern and wanting to have them aligned. for example:
this is the sample data:
Employee ID | Name | Misc | Misc 1 | Misc 2 | Misc 3 |
1234 | John Smith | Table | Chair | Plates | Forks |
8753 | Derrick Show | Plates | Forks | Knife | Sofa |
45681 | Rita Apple | Chair | Plates | Table | Forks |
this is the output i am wanting to accomplish:
Employee ID | Name | Misc | Misc 1 | Misc 2 | Misc 3 |
1234 | John Smith | Table | Chair | Plates | Forks |
8753 | Derrick Show | Plates | Forks | ||
45681 | Rita Apple | Table | Chair | Plates | Forks |
Solved! Go to Solution.
hello @atcodedog05 and @Tyro_abc both solutions worked great! I tested both and thank you for your assistance!
Happy to help : ) @utsarunner981
Cheers and have a nice day!
Glad it helped you...
Regards
abc