SOLVED
Changing Columns in Excel Document
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
IanCo
Alteryx Alumni (Retired)
‎05-01-2018
11:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have an excel document that gets new data put into it every week. However, sometimes the column order changes as shown in the attachment.
How can I prep my data to make one nice table that all the column are aligned correctly? There isn't only one line of data with every entry like the attachment.
Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
2 REPLIES 2

Inactive User
Not applicable
‎05-01-2018
04:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-01-2018
04:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @Inactive User! It looks like this solution scales to more than one row of info in the sectioned tables. Correct?
