Dealing with Horizontal Data

Question

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/15hoursratehoursratehoursrateType 11/1/15      Type 21/1/15 15 18 17.75Type 31/1/15       2/1/15hoursratehoursratehoursrateType 12/1/15      Type 22/1/15 15.25 18.5 18.25Type 32/1/15

Here is the output I need:

DateNameRate1/1/15Morrison, Jim152/1/15Morrison, Jim15.251/1/15Joplin, Janice182/1/15Joplin, Janice18.51/1/15Winehouse, Amy17.752/1/15Winehouse, Amy18.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 Answer

Hi @JBO

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

Best,

Jordan