Merge rows to only one and take data from colums

[chvizda]

Hi all

I assume it is a really simple way to do a merge from my current data set to the needed target data set.

Currently User A has a single row for every feature (It can be more than 2)

Current Dataset
User	Feature 1	Feature 2
A	x
A		x
B	x
B		x
C	X
D		X
Target Dataset
	Feature 1	Feature 2
A	X	X
B	X	X
C	X
D		X

The target should be, to have one row per user with the "X" at the right column.

Many thanks for your support.

Steffen

[cmcclellan · Accepted solution]

I would use the Summarize tool 

- Groupby User

- Concat each Feature

- then rename the Output Field Name to the existing field, like this ... 

[ponraj · Accepted solution]

Transpose and cross tab tool will help you to get desired output.