no-pivot

SELECT AD.ModulePK,
  MIN(CASE AC.ColumnName WHEN 'CompanyID' THEN AD.NewValue END) CompanyID,
  MIN(CASE AC.ColumnName WHEN 'CompanyName' THEN AD.NewValue END) CompanyName,
  MIN(CASE AC.ColumnName WHEN 'Address' THEN AD.NewValue END) Address,
  MIN(CASE AC.ColumnName WHEN 'Address2' THEN AD.NewValue END) Address2,
  MIN(CASE AC.ColumnName WHEN 'City' THEN AD.NewValue END) City,
  MIN(CASE AC.ColumnName WHEN 'State' THEN AD.NewValue END) State,
  MIN(CASE AC.ColumnName WHEN 'Zip' THEN AD.NewValue END) Zip,
  MIN(CASE AC.ColumnName WHEN 'Attention' THEN AD.NewValue END) Attention
FROM AuditData AD
LEFT JOIN
  AuditColumn AC ON AC.AuditColumnPK = AD.AuditColumnPK
GROUP BY ModulePK