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
Solved! Go to Solution.
Hey @Andrew_Fischer
You'll want to split your "headers" (the dates) off from your main table and transpose them separately.
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?
Thanks for the help @Blake! I didn't see the workflow attached. Do you mind attaching?
Thanks again @Blake !!