Preparing data for the report

[Luk88kk]

Hello everyone,

I am in the process of creating a report, and I have a problem. I have 4 same products in my table, however, two of the products has additional information. I would like to make these 4 rows into two rows with complete information. Example:

How is:

Product	Name	Rank	Group
123456789	Solenoid	300	5
123456789	Solenoid	300
123456789	Solenoid	500
123456789	Solenoid	500	2

How it should be:

Product	Name	Rank	Group
123456789	Solenoid	300	5
123456789	Solenoid	500	2

I would very much appreciate your help.

[JamesCharnley]

Hi @Luk88kk 

We can minimise data by removing rows using the Filter tool. In this instance you can use a filter tool to get rid of rows that have incomplete data by filtering out rows that are null.

[ShankerV]

Hi @Luk88kk 

Please find the expected output.

[Luk88kk]

Hello,

Thank you for your quick response.
However, an additional question arose. Because in some cases this column will be empty with a unique product, for example:

Product	Name	Rank	Group
123456789	Solenoid	300	5
123456789	Solenoid	500	2
144444444	Ring	200

So I can't use the filter tool because product 144444444 would not be included in the report.

[ShankerV · Accepted solution]

Hi @Luk88kk 

Please find the expected output.

Input was:

Many thanks

Shanker V

[ShankerV]

Hi @Luk88kk 

Step 1: Input

Step 2: Summarize

Step 3:

Many thanks

Shanker V

[ShankerV]

Hi @Luk88kk 

Step 4: Join tool

Step 5:

Step 6:

Output after Run

Many thanks

Shanker V

[Luk88kk]

Hello,

Thank you very much for your help, it works perfectly.

Have a great day and weekend.

[ShankerV]

Hi @Luk88kk 

Glad to help!!! Happy weekend to you too!!!

Many thanks

Shanker V