Split and Aggregate Output rows in same excel

[dineshbabu2811]

Hi Team,

I have a requirement Split and Aggregate Output rows in same excel, could some one help to create the output

Input

Output

[ShankerV]

Hi @dineshbabu2811 

Request you to make use of the summarize tool.

Select the option as sum under the column amount

Group byIdentifier.

Then Union the data.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @dineshbabu2811 

A sample use case to reach your solution.

Step 1: Input the data

Step 2: 

Step 3: Union

Step 4: 

Step 5: 

IF Isnull([Customer Name])
THEN null()
ELSE [Identifier]
ENDIF

Many thanks

Shanker V

[dineshbabu2811]

Thanks Shanker, it worked as expected. You're a champ man :) 

[dineshbabu2811]

Hi @ShankerV we have small change in requirement as below. I am trying to plot the value from column F, G & H and line spacing as below output but its not working. could you please help on this

Output

Thanks in advance.

[ShankerV]

Hi @dineshbabu2811 

Can you please share the input in copy and paste format.

Its in screenshot.

Many thanks

Shanker V

[dineshbabu2811]

please use this book excel, where you can find input and output in same sheet