How to create a list of categories in Excel

Help StudioX
, ,
1

Hi,
I’m in StudioX.
I have an Excel with 10 columns. I want to filter this Excel based on the Category column.
These categories are repeating in multiple rows.
I want to list of category type in a separate spreadsheet. For example, in this spreadsheet ‘Category’ column, I want the Furniture, Fruits, Electronics, Vegetables, Sweets as entries in separate spreadsheet. The program should read the category column and uniquely identify the category and copy it in a spreadsheet.
How to do this in StudioX ?

Ft1
Ft11152×648 5.2 KB

2

Hi @Prinal_C - By using the Create Pivot table, you can get the unique values

image
image567×684 19.7 KB

Output

image

Option 2: Using UIAutomation…You can choose Data → Remove Duplicates to get the unique values…

image
image1147×718 125 KB

Option 3: Again Using Automation, Choose Advance Filter, you can get the Unique records, and write it to different sheet…

image
image1069×857 55.1 KB

1 Like
3

@prasath17 thank you ! when you say 'using UI Automation…" what does it actually mean ? What should I click in StudioX ?

4

Again…multiple ways…

  1. Using App Recorder…you can try (below is just sample, not complete)

image
image432×688 26.8 KB

  1. Use Application/browser activity
5

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