Need help consolidating columns

[clafontaine]

Hello Alteryx Community:

I'm a fairly new user and need help with the attached. Any help greatly appreciated!!!

Thanks!

[CarliE]

@clafontaine  can you share the xlsx so its easier to work with?

Thanks!

[CarliE]

Hi @clafontaine 

I put together a text input as best I can, so we may need adjust based on the excel file.

It is attached and I commented the steps as well. If you have any questions, please let me know.

Mark this as a solution if this helped you 🙂

Have a nice weekend.