Creating repeating columns from a normalised DB

[alexrossiter]

Hi - I have a dataset with the following structure:

ID NUMBER	MODULE	MARK	EXAM DATE
123	ABC	70%	10/01/2020
123	DEF	80%	11/01/2020
124	GHI	50%	13/01/2020
124	JKL	55%	12/01/2020

But need it to look like this for a statutory return:

ID NUMBER	MODULE	MARK	EXAM DATE	MODULE	MARK	EXAM DATE
123	ABC	70%	10/01/2020	DEF	80%	11/01/2020
124	GHI	50%	13/01/2020	JKL	55%	12/01/2020

Does anyone have any ideas how to achieve this as I've not been able to find any comparable examples in the community.

Many thanks,

Alex 

[Emil_Kos]

Hi @alexrossiter,

I have crerated a workflow for you:

The only downside is that I needed to cheat a little bit as you can't have the same column name twice in the data. So one of the columns is called "Mark" and the second one is "Mark " etc.

I hope it will work for you!

[alexrossiter]

Thanks Emil - that works great when a student has two modules. Have you any idea how it could be extended if they are doing more - ideally so the columns continue to repeat until all modules for that ID  have been placed on the same line.

Thanks,

Alex

[Emil_Kos]

Hi @alexrossiter,

Do you know what is the max iteration? 

Actually, I don't have an answer for this from top of my head.  

[alexrossiter]

Maximum should be 8.

Thanks,

Alex

[Emil_Kos · Accepted solution]

Hi @alexrossiter,

Actually, I was able to finish this exercise. 

I learned something new with this one. Thanks for that 😄

If this works for you please mark it as a solution!

[alexrossiter · Accepted solution]

Brilliant Thanks, Alex.