Hi guys,

I am new and need some help with below.

I have excel rows in a sheet in this pattern:

NameField name1
IDField id1
NameField name2
IDField id2
CodeField cd2
NameField name3
IDField id3
.....
...

As shown in the above pattern we sometimes have no row with the codeField.

Need the output in 3 columns in this pattern

NameField IDField CodeField
Name1 id1
Name2 id2 cd2
Name3 id3

Appreciate your help

Thanks you!