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: ProductNameRankGroup123456789Solenoid3005123456789Solenoid300 123456789Solenoid500 123456789Solenoid5002 How it should be: ProductNameRankGroup123456789Solenoid3005123456789Solenoid5002 I would very much appreciate your help. test.xlsx

Preparing data for the report

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.

test.xlsx

Data Investigation

Accepted answers

ShankerV

Hi @Luk88kk

Please find the expected output.

Input was:

Many thanks

Shanker V

All comments

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.

filternulls.yxzp

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: