Transpose data set by column value and row value

[Andrew_Fischer]

Hi there,

I'm having a hard time transposing a data set and am wondering if someone could please help? I need to group by the Name column and the dates, which are in row 1.

I have something like this: 

Need something like this:

Attached is the input example. Thank you in advance!

Best,

Andy

[Blake]

Hey @Andrew_Fischer 

You'll want to split your "headers" (the dates) off from your main table and transpose them separately. 

[JosephSerpis]

Hi @Andrew_Fischer I mocked up a couple of ways to approach this that produces the output you describe. Let me know what you think?

[Andrew_Fischer]

Thanks for the help @Blake! I didn't see the workflow attached. Do you mind attaching?

[Blake · Accepted solution]

Hey @Andrew_Fischer  - sure thing! 

Sorry about that, thought I'd attached it before.

[Andrew_Fischer]

Thanks again @Blake !!