Multirow Mayhem

Question

Hey everyone,

Wondering if anyone has a smarter solution for me.  I have a dataset with header rows that contain information pertinent to the rows below.  In order to perform analytics on the dataset, I need to attribute the header row information into the corresponding rows.  This is easily achievable with the Multi-row Formula tool but when you need to do it for multiple columns, you end up in this situation which doesn't seem very Alteryx:

I've prepared an example dataset (attached) that should hopefully make it clear what the issue is.  I have a feeling a macro could do the trick here but I wouldn't know where to start. Let me know if you have any ideas!

Shifty

Multirow Mayhem.yxmd

mceleavey · Accepted Answer

Hey @Shifty ,

I have a tool for that!

It's an Autofill tool which I will be finalising soon, but attached is the working version.

I've applied it to your data as follows:

M.

DawnDuong · Accepted Answer

hi @Shifty

The key to solving is to add a RecordID tool so that you are able to keep the association between the "Records" after you transpose and use 1 single Multirow tool to do the magic. Hope this solves your problem

Happy solving.

Dawn.

Shifty · Accepted Answer

@DawnDuong @mceleavey  - Thank you so both so much.  I have a macro to use and I also know how to do it smarter in future.  Ideal outcome!