[image] [image] 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.

Organising complicated multiple column data into row data

Wei_Ji_Kwok (Wei Ji Kwok) October 19, 2022, 2:48pm 8

example.xlsx (12.3 KB)
Here u go

Topic		Replies	Views
Organising the form of output by changing multiple column to row Studio studio , question , activities_panel	1	539	October 20, 2022
Data Row To Data Table Help datatable , activities , question	11	905	November 9, 2019
Excel with email Studio	4	790	May 25, 2020
Modify Body of email adding multiple column data from excel Studio	3	390	June 28, 2023
[HELP] Merge all unique email ids from Datatable and send 1 email to all of them using outlook Studio datatable , mail , outlook , studio , question	7	1378	March 22, 2021