Aligning the value of a row and making it a column

[Cherub7210]

i wish to have the output arrange this way appreciate 

ID	Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
PR06278	ABCD		2024-05-03		09:09:21 PM		00:00:00

Based on this dataset. Appreciate the help!

Time Tracking
PR06278
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD		2024-05-03		09:09:21 PM
Total						00:00:00
PR05306
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD	ABCD	2024-04-29	2024-04-29	05:22:45 PM	10:33:13 PM	05:10:28
Total						05:10:28
PR05837
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD	ABCD	2024-04-29	2024-05-01	05:20:25 PM	01:04:30 AM	31:44:05
Total						31:44:05
PR121271
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD		2024-05-03		11:15:56 PM
Total						00:00:00
PR06024
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD	ABCD	2024-05-06	2024-05-08	09:20:57 PM	02:23:48 AM	29:02:51
ABCD	ABCD	2024-04-23	2024-04-23	12:38:10 AM	12:38:15 AM	00:00:05
Total						29:02:56
PR05326
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD	ABCD	2024-05-07	2024-05-07	03:54:57 AM	09:54:15 PM	17:59:18
ABCD	ABCD	2024-05-06	2024-05-06	09:16:25 PM	09:50:53 PM	00:34:28
Total						18:33:46
PR05327
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD	ABCD	2024-05-07	2024-05-08	09:54:39 PM	01:57:11 AM	04:02:32
Total						04:02:32
PR06375
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD	ABCD	2024-04-29	2024-05-06	05:21:44 PM	11:58:17 PM	174:36:33
Total						174:36:33
PR06025
Started By	Ended By	Start Date	End Date	Start Time	End Time	Duration
ABCD		2024-05-08		02:49:24 AM
Total						00:00:00

[Brando]

Hey @Cherub7210,

Here's a solution for you in with only a few tools, just involves some data cleaning!

Cheers,

[Cherub7210]

thank you for the solution Brando, is there a way we include the ID?

[Cherub7210]

thank you for the solution, is there a way we attach the item to the column outputs?

[Brando]

@Cherub7210 you bet, apologies for missing it on the first go around!

Adding the ID might be a touch more challenging but it's certainly possible to accomplish. I'm taking a look!

[cjaneczko · Accepted solution]

Try this following.

[Cherub7210]

Thank you this works! 

Can i also ask if i use multiple sheets of excel to go through the same process, should i utilize a macro? and how should i configure that?

[cjaneczko · Accepted solution]

You'd want to use a batch macro. Take a look at this macro

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Input-Batch-Macro-AKA-the-Extr...

And then look at this flow chart.

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[Cherub7210]

thank you so much