Moving column values to identical empty columns

Hi Alteryx Friends,

This is difficult to explain so it's best to watch the picture to understand. It shows what I have and what I want. I basically want to move the "BeerTried" values to the left so that BeerTried1 is always populated and then BeerTried2 but never have any empty values and then another value after that.

Any ideas?

Best regards,

Peter

Capture.PNG

Tips and Tricks

Best Practices

Transformation

Preparation

Expression

Accepted answers

Kenda

@PeterPetersen sorry about that. I revised the version number and reattached the workflow to this post.

move column values.yxmd

All comments

Kenda

Hey @PeterPetersen! Check out the attached workbook to see if that's what you're looking for. The key was to use the Transpose and Cross Tab tools. Hope this helps!

move column values.yxmd

PeterPetersen

Dear BarnesK,

Thank you for your fast response. Unfortunately I cannot open the document as it was made by a newer version and I'm running at 10.5.9 ATM and unable to update due to company policy.

Could you maybe post a screenshot?

Best regards,

Høgni

Kenda

@PeterPetersen sorry about that. I revised the version number and reattached the workflow to this post.

move column values.yxmd

PeterPetersen

You're too kind. I actually figured out how to open the original file using this guide to change it to version 10.5: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Adjusting-Alteryx-Files-for-Different-Versions/ta-p/26237

Thank you for your help!

Kenda

Awesome @PeterPetersen! That is actually the same change that I made before I uploaded it the second time. Glad the solution worked for you and you can use that Notepad ++ trick in the future!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167