Transpose a pivot to a table

**gmgmstl** · 03-01-2017, 04:42 AM

Hi,

Hope I'm in the right place.

I'm trying to transpose a pivot table in an automated way somehow.

Here and attached is a file with 2 sheets, the first one is the data and the second is the desired format of the table.

I would love to get some insight on how to do it ( not manually

Thanks in advance,
Ron.

**dflak** · 03-01-2017, 02:21 PM

Did you really wish not to include the email address that is on the same row with the Owner Email? I decided that you did not. If so, it's only a minor modification of the code to change this.