SOLVED
Transpose rows to columns based on Record ID field
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
Sudkakani
5 - Atom
‎07-26-2020
10:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Guys,
I am trying to transpose some data from rows to columns based on ID, but getting incorrect results.
Input data:
Record ID | Name | Value |
1 | Year | 2000 |
1 | Category | Pen |
1 | Customer Name | Rayn |
1 | Export | Germany |
2 | Year | 2001 |
2 | Category | Paper |
2 | Customer Name | John |
2 | Export | USA |
But the expected output should be like this
Record ID | Year | Category | Customer Name | Export |
1 | 2000 | Pen | Rayn | Germany |
2 | 2001 | Paper | John | USA |
Attached input file
Thanks
SudK
Solved! Go to Solution.
Labels:
- Labels:
- Developer
2 REPLIES 2
jasperlch
12 - Quasar
‎07-26-2020
10:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎07-26-2020
10:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes and Thanks @jasperlch
