Group Excel Cells

Help Studio
, ,
1

Hello there!

I Have an Excel file like this:
image

I need to group some values of the second collumn in one, like this:
image

How is it possible?

Thanks in advance.

2

Hi @luan.quirino1
May i know what is the criteria which we used for grouping ?

3

Hello @luan.quirino1 This is the solution, You Just need to Type File Path in the Excel Application Scope One Value with Multiple Values 2.xaml (8.2 KB)

Let me know if you have any cuestion

4

If the numbers in the first column are the same, group the itens in the second and third column in only one cell.

5

It Worked Great. Thank you, so Much!

1 Like
6

Great @luan.quirino1 Can you marked as solution please?

1 Like
7

Thank you so much, but I’ve another issue.
In my exemple file, there are only 3 columns, but in the file I’m working there are 30.
I need to filter just 3 of the itens, like in the exemple. running your workflow returns me only the filtered itens. I need to filter them and keep all the other columns. For exemple

Turn this:
image

Into This:
image

8

Ok let me work on that, Can you shared the complete Example to create the correct query

10

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