Trasfering data from one column to multiple

Question

Hi team,

I am stuck on one thing I need to do in ateryx I need to do.

I have a set of data from accounting deparment - document numbers and related account numbers. Currently I have 1 column with all document numbers and another one with accounts. The problem is, that to one document number, there are several account numbers which I need to bring into one row with the document number (see below how it should look like).

Input   Output      Doc numberAccount  Doc numberAccountAccountAccountAccountAccountAccount1abc  1abcdef    1def  2abcdef    2abc  3defghimno   2def  4abcjklghi   3def  5abcdefghijklmnopqr3ghi         3mno         4abc         4jkl         4ghi         5abc         5def         5ghi         5jkl         5mno         5pqr

Ive tried to do that with some summarize, transpose or cross tabs, but clearly I am doing something incorrectly.

Can anybody help?

Thanks in advance.

RolandSchubert · Accepted Answer

Hi @DominikaD ,

you could use a Multi-Row formula tool to add a "counter" to the accounts for each document - it's possible to cross-tab rows to columns then. Attached a sample workflow. Hope this is helpful.

Best,

Roland