Generate duplicate row for each column containing data

[MB31]

Hi, All

I am pretty new to Alteryx and am looking for a way to generate duplicate rows for each column that has data in it as well as move the column data to the newly created row. I did see the Generate Rows tool, but unfortunately it seems complicated when non-numerical data is used.

Any help/advice would be appreciated

Sample data

Task	Preparer	Reviewer 1	Reviewer 2	Reviewer 3
Task 1	Person A	Person B	Person C	Person D

Desired result

Task	Name
Task 1	Person A
Task 1	Person B
Task 1	Person C
Task 1	Person D

[ZacharyM · Accepted solution]

The generate rows tool is used to add rows to data of the same structure (think 'fill in the data') - in your case, you want to re-structure the data, so a few steps are likely required.

I expanded on your example data a bit to make sure that my solution would capture not just your sample, but the full use case.

Please let me know if I missed something - if this solves your issue, please mark this as an accepted solution so people know you've been helped :)

Cheers!

Zak

[DavidP]

The Transpose tool will do this for you if you group on Task