Creating a long list of data

Question

I need to arrange my data in a table which has only 3 columns - Site ID, attribute aggregation (Time + Metric + Type), Metric value. I tried using the transpose but that is not working. Can someone please suggest the best way to do this? Thanks!

Current

SitePeriodRevenuesUnitsCustomer Type1TY10010A1TY9511B1LY1059C

Desired

SiteAggMetric1TY Rev A1001TY Units A101TY Rev B952  2

jdunkerley79 · Accepted Answer

First use a Transpose table to convert to Site, Period, Customer Type, Name, Value

You can then use a Formula tool to make the Agg field

Finally a select to rename and drop columns

DultonM · Accepted Answer

Hi anujkasera!

You're almost there! To add to jdunkerley79's post:

Choose Site, Period, and Customer Type as your "Key Fields" in the Transpose tool. I've attached a workflow (built in 10.5) that demonstrates this and the Formula/Select tools that should follow.

UPDATE: Oops! Didn't realize jdunkerley79's post also included a workflow! Looks like you get extra assurance that this'll work :)