Transforming Account Contact Data

[mstoler]

Hello,

I need to transform the sample data in the Input Sheet of the attached excel file to the output sheet.

My input data is structured like this.

My output data needs to be like this

I can do this with a filter and select, Union and Summarize  but I was wondering if there is an easier way.

Thanks,

Michael

[fmvizcaino · Accepted solution]

Hi @mstoler ,

You can get that result by playing with transpose + cross-tab tools.

Here is an example for you.

Best,

Fernando Vizcaino

[payam2 · Accepted solution]

Hi Michael,

Transpose and Cross Tab tools can make the process much easier. See if the attached solution works for you.

[mstoler]

Excellent.

The image you provided made it clear and I implemented it.

Michael