Summarize the dataset

[Ekta]

Dear All, 

please help me with this-

I have an input file like this with multiple lines, i need to summarize them like the output i have provided down-

input data -

A   |B  |    D |  E

1    K             Z

1    K      X

1    K      Y

2    M     

2    M      P

2    M            Q

2    M

3    S

Output data-

A    B      D      E

1    K      X       Z

1    K      Y  

2    M      P       Q

3    S

[DanielMS · Accepted solution]

Hi @Ekta

I have attached a workflow that should do what you have requested.

Please give it a try and get back to me.

Dan

[Ekta]

Thank you so much, worked perfectly fine.