How do I convert unique values in a column to individual rows

[SrikarE]

Hi everyone,

I am trying to convert unique values in a column to separate rows, see below the sample data and expected output. I have tried using 'text to columns', 'Transpose', and 'Cross Tab' fields but couldn't achieve the expected outcome.

Can someone please help me out.

Sample Data

EE Number	Earning Type	Amount
1	a	2000
2	b	4000
3	c	6000
4	d	8000
5	e	10000
1	b	3000
3	e	5000

Expected Output

EE Number	a	b	c	d	e
1	2000	3000
2		4000
3			6000		5000
4				8000
5					10000

Thanks in advance.

[JosephSerpis · Accepted solution]

Hi @SrikarE you can use a crosstab to achieve your desired results.

 

[SrikarE]

It worked! Thank you for a quick response.