Move Row value to Column

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

Datasets

Accepted answers

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

Workflow:

Hope this helps : )

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

Workflow:

Hope this helps : )

That works great!

dshay