I'm brand new to Alteryx (like 2 days) and one of the first workflows I wanted to tackle I thought would be easy but I have not been able to figure it out. I have a bank report I pull and copy into Excel. Currently I do a formula in Excel to copy one cell up into another cell then perform a couple of text to column routines. My hope was I could build something in Alteryx to be able to do this with a push of a button. Would something like this be easier just to keep doing in Excel? I attached a sample of the bank report we receive. Basically we need to get the Store ID in one column and the credit amount associated with that Store ID in another column.
