Adjust rows into a column and append data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ok, I'm very new to Alteryx and just trying to do a simple workflow to get my bearings and a foundational understanding. My biggest issue is what I am guessing is probably easy stuff, but I've done some searching and can't find anything applicable.
Basically I am taking data that looks like (note - "company" field is not in original data):
And trying to convert it into:
I know how to do the formula stuff (vlookups/hlookups/sumifs), but I am having trouble getting the row with the company # into a column on its own. I may be trying to do too much in a single step, but it seems like every single tool I click on only applies to manipulating columns.
Bonus points for how I would replace the data in the 2nd SS with new data in an existing file (i.e. when going to the next month).
I'm sure this has been asked/answered somewhere previously but I was having trouble finding anything.
Thanks!
Solved! Go to Solution.
- Labels:
- Datasets
- Help
- Parse
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
