How to transpose columns to rows and put headers in the row too

[Carl_in_CT]

OK, one more today, hoping to finish this data output today.

I have to transpose this:

Transaction Type	Benefit Month	code 5601	code 5602	code 5603	code 5604
TRN	12/18/2018	175.5	48
PRK-CR	12/18/2018			50	0

Into this:

Transaction Type	Benefit Month
TRN	12/18/2018	code 5601	175.5
TRN	12/18/2018	code 5602	48
TRN	12/18/2018	code 5603
TRN	12/18/2018	code 5604
PRK-CR	12/18/2018	code 5601
PRK-CR	12/18/2018	code 5602
PRK-CR	12/18/2018	code 5603	50
PRK-CR	12/18/2018	code 5604	0

I can transpose the data fine but I can't figure how to get the "code" field headers to be included in the new rows.

[Thableaus · Accepted solution]

Hi @Carl_in_CT

Isn't this config good for your solution?

Cheers,

[Carl_in_CT]

Unless I'm missing something that doesn't bring the code headers into the row, just the data.

[Thableaus]

@Carl_in_CT

It actually does.

See WF attached.

Cheers,

[Carl_in_CT]

Yeah, when I run yours it works but mine does not but it looks like it's set up the same, I just have more fields in the real version.

[Thableaus]

Hmm..I see.

Could you please just post a printscreen of how your transpose tool is configured? So we can check if there's anything else missing.

[Carl_in_CT]

[Carl_in_CT]

Woops, that pic was wrong, I had been tinkering to try to get it to work.  This is the real thing.

[GrahamL]

Hi there

Looking at your screenshot, it looks like columns 5601-5604 shouldn't be checked in the key fields dialog.

Hope this helps

Cheers

G

[GrahamL]

Ignore last post as I was looking at the old screenshot!

Is it the deduction amount or subsidy amount you want as values as you have one checked as a key field and the other checked as a data field

Cheers

G