Dealing with Horizontal Data

[JBO]

Hello

I received an ugly horizontal data set. Here is an example of what it looks like (note, there are 66 names in my data with about 73 dates):

		Morrison, Jim		Joplin, Janice		Winehouse, Amy
	1/1/15	hours	rate	hours	rate	hours	rate
Type 1	1/1/15
Type 2	1/1/15		15		18		17.75
Type 3	1/1/15
	2/1/15	hours	rate	hours	rate	hours	rate
Type 1	2/1/15
Type 2	2/1/15		15.25		18.5		18.25
Type 3	2/1/15

Here is the output I need: 

Date	Name	Rate
1/1/15	Morrison, Jim	15
2/1/15	Morrison, Jim	15.25
1/1/15	Joplin, Janice	18
2/1/15	Joplin, Janice	18.5
1/1/15	Winehouse, Amy	17.75
2/1/15	Winehouse, Amy	18.25

I have already attempted this a few ways, but I am not able to solve it. Is there anything like a Multi-Column tool I could use to pair the rates in D, F, and H with the names in C, E, and G?

Any guidance on this one is much appreciated. 

Thanks in advance. 

Jen

[JordanB · Accepted solution]

Hi @JBO

Please find attached a sample workflow which gets the desired output. I have added annotations within the workflow.

Best,

Jordan

[JBO]

@JordanB, thank you so much! This is awesome.

My data is more complicated than what I shared here and I was able to use this as a foundation.