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!
Solved! Go to Solution.
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.
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.
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.
@mceleavey @AkimasaKajitani Thanks.
Transpose replaces special characters "()" and spaces with "_" how can we fix that. Please
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 :
Thanks a ton buddy...!
@AkimasaKajitani Perfect ....!