Transposing Data

tinadee

Hi all, 

I have data like this 

Team	Name	10-7-2019	10-8-2019	10-9-2019	....
A	Sam	Avail	Avail	Not Aval
A	Tom	Not Avail	Not Avail	Avail
B	Jerry	Avail	Avail	Not Aval
C	Sarah	Avail	Not Avail	Avail
C	Susan	Avail	Avail	Not Aval
D	Jon	Avail	Not Avail	Avail

I would like it to look like this for all data points. 

Team	Name	Date	Availability
A	Sam	10-7-2017	Available
A	Tom	10-7-2019	Not Avail...

Essentially I want the first two columns to remain the same and only want to transpose the date and availability column information into rows. 

Thank you, 

jrgo

Hi @tinadee 

Unless there's some detail i overlooked, the Transpose tool should be what you need. Select tool after is used to rename the pivoted fields to "Date" and "Availability".

Here's the configuration of the Transpose tool