Splitting Multiple entries into different columns

[alkesh_sharma]

Hello Experts,

I have a data in below format:

Invoice No.	Scheme Code
121	A01
121	A02

I need the same data in below format:

Invoice No.	Scheme Code1	Scheme Code2
121	A01	A02

Thanks in advance

[senpradip007 · Accepted solution]

Have a look on the attachment. Hope it will solve your problem.

[alkesh_sharma]

Thanks Sir, this will do the trick...:)

[senpradip007]

welcome!!!!