Summarize the dataset

Question

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 Answer

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