Split Row Data in Columns

[hemant86]

Hi All,

My input looks something as below:

EMPID	Description	Type	Total Amount
1111	RELOCATION ALLOWANCE	Allowance	19560
2222	RELOCATION ALLOWANCE	Allowance	18056
3333	INTERNET ALLOWANCE	Allowance	21794
4444	INTERNET ALLOWANCE	Allowance	75935
5555	INTERNET ALLOWANCE	Allowance	40587
6666	RELOCATION ALLOWANCE	Allowance	22922

Required OUTPUT:

EMPID	RELOCATION ALLOWANCE	INTERNET ALLOWANCE	Type
1111	19560		Allowance
2222	18056		Allowance
3333		21794	Allowance
4444		75935	Allowance
5555		40587	Allowance
6666	22922		Allowance

Appreciate any help on this. Thanks in advance.

[Christina_H · Accepted solution]

You just need a cross tab tool for this.

[hemant86]

Thanks @Christina_H That worked great for me...Actually I was trying to use the Cross Tab and Transpose but tools setting for Cross tab were incorrect.

Thanks again for your help🙂