Transforming Account Contact Data

Question

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 Answer

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 Answer

Hi Michael,

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