Transpose data set by column value and row value

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

Transpose Example.yxmd

Workflow

Datasets

Best Practices

Transformation

Preparation

Accepted answers

Blake

Hey @Andrew_Fischer - sure thing!

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

Transpose Example.yxmd

All comments

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?

Transpose Example.yxmd

Andrew_Fischer

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703