How to transpose columns to rows and put headers in the row too
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Unless I'm missing something that doesn't bring the code headers into the row, just the data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Woops, that pic was wrong, I had been tinkering to try to get it to work. This is the real thing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
