row to coloumn with additional coloumn

Raj_2

Hi team, need a help to convert row format to coloum and add new header, sample below and expected

Sample

EID Code Code Amount

1 5 100

1 6 200

2 6 150

2 8 100

Expected

EID Code Code Amount Code Code Amount

1 5 100

1 6 200

2 6 150

2 8 100

so need to create a running coloumn based on eid, code and amount.

Thank you

Preparation

Accepted answers

Jonathan-Sherman

Hi @Raj_2,

The only change that needs to be made is to un-tick the "Name2" field in the final cross tab tool. This should give you the result you were looking for.

If this solves your issue please mark the answer as correct, if not let me know! I've attached the updated workbook for you to download if needed.

Regards,

Jonathan

row to coloumn with additional coloumn.yxmd

All comments

JoshuaGostick

Hi @Raj_2,

I've built a workflow that converts your sample data to the expect results using the Transpose and Cross Tab tools. Is the workflow working as you would like it to?

row to coloumn with additional coloumn.PNG

Thanks,

Josh

row to coloumn with additional coloumn.yxmd

Raj_2

Thank you, It is 99%, I need a correction, how can I get the additional col in same line, now it is one below another based on EID. So , one EID one line and running code and amount col expected.

Thanks again, please help if it is a small change

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703