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!!

[Luke_C · Accepted solution]

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.

[Zumanalyst]

This is brilliant!! Thank you @Luke_C