Move Row value to Column

[dshay249]

Hi all,

I need to move the   row value   in the following  example to  a column :     

Dataset

Field 1

Group 1

ABC

DEF

ABC

Group 2

ABC

DEF

GHI

Desired result

Group 1      ABC

Group 1      DEF

Group 1      ABC

Group 2      ABC

 Group 2      DEF

Group 2      GHI

Thanks any help will be appreciated.

dshay

[atcodedog05 · Accepted solution]

Hi @dshay249 

Here is how you can do it. Using multi-row formula tool to fill down the group.

Workflow:

Hope this helps : )

[dshay249]

Thanks,   atcodedog05

That works great!

dshay

[atcodedog05]

Happy to help : ) @dshay249 

Cheers and have a nice day!