Trasfering data from one column to multiple

[DominikaD]

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 number	Account			Doc number	Account	Account	Account	Account	Account	Account
1	abc			1	abc	def
1	def			2	abc	def
2	abc			3	def	ghi	mno
2	def			4	abc	jkl	ghi
3	def			5	abc	def	ghi	jkl	mno	pqr
3	ghi
3	mno
4	abc
4	jkl
4	ghi
5	abc
5	def
5	ghi
5	jkl
5	mno
5	pqr

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 solution]

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

[DominikaD]

Thank you!

You are my absolute hero!