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.