Converting first column as header

[Usman_Ahmad]

Hi Everyone,

I want to convert the input data to output as mentioned below.

Input:

Client Name	Project
A	X1
A	X2
A	X3
B	Y1
B	Y2
B	Y3
C	Z1
C	Z2
C	Z3

Output:

A	B	C
X1	Y1	Z1
X2	Y2	Z2
X3	Y3	Z3

Many thanks in advance.
Cheers!

[AkimasaKajitani]

Hi @Usman_Ahmad 

You can use CrossTab tool to achieve this output.

But before using it, you have to use Tile tool to get sequence number of each Client Name.

Tile Setting

CrossTab Setting

Please refer the uploaded file.

[Usman_Ahmad]

Thanks @AkimasaKajitani . 
But my actual data has multiple words as client name i.e ABC Co limited. When I transpose the data it give me "ABC_Co_limited"
How can I get rid of "_" in the headers?

Thanks again.

[mceleavey · Accepted solution]

Hi @Usman_Ahmad ,

I've used a bit of transpose and cross-tab magic for this:

I've also used a tool I built which I've attached. You'll need to save this in your macro folder.

M.

[AkimasaKajitani · Accepted solution]

Hi @Usman_Ahmad 

You can use Dynamic Rename tool to delete "_".

[Usman_Ahmad · Accepted solution]

@mceleavey  @AkimasaKajitani Thanks.

Transpose replaces special characters "()" and spaces with "_" how can we fix that. Please

[mceleavey · Accepted solution]

@Usman_Ahmad ,

Use the Dynamic rename tool.

Rename with formula:

replace(names,"_"," ") etc.

M.

[AkimasaKajitani · Accepted solution]

Hi @Usman_Ahmad 

I would like to show the another way.

I added the Unique tool and change the option of Dynamic rename tool.

Unique tool setting : 

Dynamic Rename tool setting :

[Usman_Ahmad]

Thanks a ton buddy...!

[Usman_Ahmad]

@AkimasaKajitani Perfect ....!