Table Transformer with Column Headers

jacque_french

Hello,

I am trying to use Table Transformer and Table Except and Table Except Include to create a roll up view of ongoing projects. The problem I am running into is that the project documentations were all setup using Column Headers, aka, left handed column headers instead of a traditional Heading Row.

Is it possible to use these Macros when my charts are utilizing Column Headers vs Row Headers?

Katerina Kovriga {Stiltsoft}

Hi @jacque_french ,

Go to the Table Transformer macro settings: Settings tab -> Transpose Source Tables or Transpose Result Table.

With these options your source or result tables automatically change their view from Column Headers to Row Headers (or vice versa). Hope this may help your case.