Transpose then Join
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
cfrederes1
5 - Atom
‎10-09-2024
11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm attempting to make a 'flat' row by the field "TN" below- I can us the crosstab function and receive the output of the highlighted fields but I can't join to bring the correlated MRC and Qty field for every USOC.
INPUT:
DESIRED OUTPUT:
Labels:
- Labels:
- Topic of Interest
1 REPLY 1
21 - Polaris
‎10-14-2024
02:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@cfrederes1
It can be completed with the combination of Transpose and Cross Tab and not that The duplicated fields names are not allowed.
