combining/merge columns

[utsarunner981]

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

[atcodedog05 · Accepted solution]

Hi @utsarunner981 

Here is how you can do it.

Workflow:

Hope this helps : )

[Tyro_abc · Accepted solution]

Hi @utsarunner981 

Try this..

[utsarunner981]

hello @atcodedog05  and @Tyro_abc  both solutions worked great! I tested both and thank you for your assistance! 

[atcodedog05]

Happy to help : ) @utsarunner981 

Cheers and have a nice day!

[Tyro_abc]

Glad it helped you...

Regards

abc