Transform data from groups/categories in rows into columns with headers

Zumanalyst

Hi Alteryx community,

Apologies if my header doesn't properly describe my problem - the attachment should better explain what I'm looking for.

My table is currently grouped by name, date, and line/queue, and I'd like to rearrange so that it's simpler to work with for analysis and visualization.

Please see attachment for sample data and desired output. Will greatly appreciate any help / ideas I can get. Thank you!!

User performance.xlsx

Luke_C

Hi @Zumanalyst 

Here's an example with the multi-row tools. Each looks for a pattern, in this case the date format and employee name (based on consecutive words beginning with uppercase letters). Then I filtered down to the actual data to remove the sums.

New Workflow1.yxmd