need help in column structure

[Naga]

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_Y	Y	Name_Y	Y
Address		Address	Y
Zip		Zip	Y
County		County	Y
Name_N	N	Name_N	N
Address		Address	N
Zip		Zip	N
County		County	N
Status		Status	N

Thanks

Naga

[TomWelgemoed · Accepted solution]

Hi,

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

Regards,

Tom

[TomWelgemoed · Accepted solution]

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.

[Naga]

Thanks Tom...This helped my need...:)

[TomWelgemoed]

Happy it helped!