How i can group value in excel

Help Activities
, ,
1

Hello Everyone

I need help, please.

I have 3 columns Mark, Name, and Class.

data in mark and name it can change but class is fixed.

1

I try to create like this result

result

could anyone help me, please

Thank you.

2

Hi do u need to create the results in one cell for A, B , C seperately ( results )

3

Hi @NIVED_NAMBIAR it is okay. the idea is I need to get the name with a mark one by one. the issue is how the boot knows if there is now more value in the first name.

4

Hi @Dev2 ,

I’m a beginner in LINQ. I hope my solution fits your requirement.

Input:
input

Output:
output

LINQ:
dt_Output =
(From d In dt_Input.AsEnumerable
Group d By k=d(“Name”).toString.Trim Into grp=Group
Let row = New Object() { k + vbCr + String.Join(vbCr, grp.Select(Function ( r ) r(“Marks”).toString.Trim).toArray) }
Select dt_Output.Rows.Add(row)).CopyToDataTable

Workflow (With All Files):
Sample.zip (71.3 KB)

2 Likes
5

Hi @Dev2
check this workflow
sample.xaml (9.9 KB)

Regards,

Nived N
Happy Automation

1 Like
6

Hi @Shraddha_Gore

Thank you for your help, it is helpful. But how I can process it one by one. For example, first I want to get A, with 90 and 35, and process. Then next value etc…

7

Thank you @NIVED_NAMBIAR

I will check

1 Like
8

Hi @Dev2 ,

As per my knowledge, it is already processing one by one group.

As I’m grouping by Name (A, B, C, etc).
So, first we have A.
String.Join(vbCr, grp.Select(Function ( r ) r(“Marks”).toString.Trim).toArray gets Marks one by one related to A (group item) & joins each item with new line seperator. Similarly , it continues for other groups (B, C etc.)

1 Like
9

@Shraddha_Gore Thank you for your help :innocent:

1 Like
10

Thank you @NIVED_NAMBIAR .

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.