Multiple Records into One Field

[Paddydd]

Hi All

I've been given some data and asked to find the blank values. I did a transpose and all worked great.

This is an example of the Data I have

Type       Account       Field             Count

Header   0001            ABC                 1

Header   0001            DEF                 1

Detail      0001           ZZA                  1

Detail      0001           ZZB                  1

Detail      0001           ZZC                  1

Header   0002           ABC                  1

Detail      0002           ZZA                  1

Detail      0002           ZZB                  1

Detail      0002           ZZC                  1

Detail      0002           ZZD                  1

However my boss now wants it summarising in a certain way and I just cant fathom out how to do it

What is now wanted is

Type       Account       Field                         Count

Header   0001            ABC,DEF                      2

Detail      0001           ZZA, ZZB, ZZC             3

Header   0002           ABC                               1

Detail      0002           ZZA, ZZB, ZZC, ZZD    4

Can anyone help me ? Any help would be very gratefully received.

Many Thanks

Paddy

[binuacs · Accepted solution]

@Paddydd try the summarize tool

[Raj · Accepted solution]

@Paddydd 
find the workflow attached

mark done if solved.

[NidhiSethi]

Hi,
Just use the summarize tool to get the total count.

If you wish to get the field in same string, try find and replace and concatenation.

[Paddydd]

Thank you everyone for such a quick response. I cant believe I missed that. Thank you again.