pillar data normalization and organization