Data Transformation

[hjm35055]

Hi,

Below you can see the current data that I have and what I need it to look like.  If I only had 3 "fruits" I think I could do this on my own the long way; however, I have 97 "fruits" and am wondering what the quickest way to do this is.  I was originally thinking the generate rows tool but am fairly new to Alteryx.  Thanks in advance for your help!!

[MarqueeCrew · Accepted solution]

TRANSPOSE TOOL:

Key = Customer ID

Data = Select all fruits....

That one tool should be a favorite (favourite) for sure!

Cheers,

Mark

P.S.  After you transpose it, you could filter by Value > 0 and the use a Select to drop the value column

[hjm35055]

Thank you!!!!!