SOLVED
I am trying to pivot/rearrange data as shown below
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
ahsankhalid
8 - Asteroid
‎07-18-2024
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have about 300 files to read the sheet1 from it have a list as shown on the left of the picture and I want to show the data as shown on the right. I want to create columns for all unique value of ColType and put the selection in respective columns. So look at the column heading and area and put the selection there. This is a sample data. real data is about 47K records.
 
Solved! Go to Solution.
Labels:
2 REPLIES 2
dwstada
11 - Bolide
‎07-18-2024
08:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎07-18-2024
08:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Genuis!!!!
