need help in column structure

Question

Hi Team,

I have the below input, which I need to bring like in output. Just I need to categorize and fill the blanks to group accordingly.

Input Output Name_YYName_YYAddress AddressYZip ZipYCounty CountyYName_NNName_NNAddress AddressNZip ZipNCounty CountyNStatus StatusN

Thanks

Naga

TomWelgemoed · Accepted Answer

Hi,

Think you simply need a multirow tool & formula - attaching a solution for you. Also see screenshot below.

Regards,

Tom

TomWelgemoed · Accepted Answer

FYI, if you did need the Input column repeated, you can simply do that with a Formula tool and call the new field (e.g. "OutputField") and the formula would simply be the fieldname "Input".

Another image below to demonstrate.