Organising complicated multiple column data into row data

[Wei_Ji_Kwok]

One team member will giving mark to other 5 people, so i will have 5 column of email(might be 4) with marks for each person, How can i change the data in first image in to second image ? Appreciate for your reply.

[RajKumar_DC (RajKumar Durai)]

Hi @Wei_Ji_Kwok ,

Use “Filter Data Table” activity. just add needed column name

input

output

Thanks,
Rajkumar

[Sudharsan_Ka]

Hi @Wei_Ji_Kwok

Note: All the column headers should have a unique name

• Read Range and add the properties Add headers if unique row headers else disable add headers
• You can try with Filter datatable activity and use output columns and select on Keep and add your column names if you have unique headers else add the index
  
  
  
  

You can also try this expression to get only those columns if you have unique column headers

dt.DefaultView.ToTable(False,"Col1","Col2","Col3")

Hope this Helps

Regards
Sudharsan

[Wei_Ji_Kwok]

Hi, im not able to do that,

I need to move multiple email column with the marks given for the email into one row (each email column have unique name) just like image i show.

[Wei_Ji_Kwok]

First image was how i test and second image show like this but i hope to make every single email in one row

[supermanPunch (Arpan)]

Hi @Wei_Ji_Kwok ,

Could you Provide us with the Sample Input data and the Expected Output data in the form of Excel files ?

We could avoid confusions of the logic that needs to be devised and suggest/provide you with the appropriate approach.

[Wei_Ji_Kwok]

example.xlsx (12.3 KB)
Here u go

[Wei_Ji_Kwok]

Originally, In each row contain multiple email with the mark given to the email. I hope to convert the way into expected sheet. Expected sheet was the output i hope to see. Any suggestion to solve this problem? Appreciate for your idea

[supermanPunch (Arpan)]

Hi @Wei_Ji_Kwok ,

We see that there is an irregularity in the Column Names at the end, could you confirm if it is a Typo error or It would be present as it is ?

We do not have the last column, Another Team Member for Evaluate (Team member 8) , also an irregularity is seen on the First row.

Let us know what is the outcome you expect to be done on this.

[supermanPunch (Arpan)]

Duplicate : Organising the form of output by changing multiple column to row