SOLVED
Transform Tools - Rows to columns
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
AmAm
7 - Meteor
‎04-27-2022
11:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to shift the rows into columns. I know that I should use transformation tool, I tried few but it did not work. So I want some help plz.
Thank you in advance,
I have this
and I want this
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
- Workflow
3 REPLIES 3
17 - Castor
‎04-27-2022
11:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @AmAm,
You need to have name as a key column and the rest as data columns. Like so (I've attached an example workflow):
The key columns will remain the same and the data columns will pivot round them.
‎04-27-2022
11:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@IraWatt Thanks man!!
17 - Castor
‎04-27-2022
11:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries at all ! :)
