Transposing dates from within the data into rows

Question

The below data shows dates from columns D to H. I need these transposed to they're all in rows in one single column (if that makes sense).

How do I do this?

Yoshiro_Fujimori · Answer

Hi @rossmike ,

It sounds like a typycal use case for Transpose tool.

Workflow

Transpose tool configuration

Output

Is this what you mean?

Transpose.yxmd

flying008 · Answer

Hi, @rossmike

Maybe this answer of post can give you a tips.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-Merge-2-or-more-column-data-into-one-single-row-like/td-p/1127708