Transpose of Data
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
prveenk86kumar
7 - Meteor
‎06-05-2022
01:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All, I am trying to transpose attached input file_1 to columns but everything is getting displayed in one column. I need the data in below summary format and only selected columns.
Labels:
- Labels:
- Data Investigation
3 REPLIES 3
FrederikE
13 - Pulsar
‎06-05-2022
02:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For this kind of Problem you often need a Summarize and Text to Column Tool as well.
Check the attached solution.
Also you might want to check out the "Total Transpose" Macro - I like to use this for such problems.
suby
11 - Bolide
‎06-05-2022
02:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎06-05-2022
02:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/0052A40480681DBBC707042CBFDD66A8/responsive_peak/images/icon_anonymous_message.png)