Cross tab with strings

[Arg0n11]

Hi All,

How would I go about doing both of the below:

1. How would I convert table (1) to the format shown in table (2)

Table (1)

Term	Definition
USD	US Dollar
AUD	Australian Dollar
ZAR	South African Rand

Table (2)

Term 1	Definition 1	Term 2	Definition 2	Term 3	Definition 3
USD	US Dollar	AUD	Australian Dollar	ZAR	South African Rand

2. How could I then add columns after Definition 3 in table (2) to get to specified number of columns, say 5, as per below. I am asking this as the number of definitions and terms could differ for each run but need set columns for my tool to work

Term 1	Definition 1	Term 2	Definition 2	Term 3	Definition 3	Term 4	Definition 4	Term 5	Definition 5
USD	US Dollar	AUD	Australian Dollar	ZAR	South African Rand	Null	Null	Null	Null

[ImadZidan · Accepted solution]

Hello @Arg0n11 ,

here is an idea. Hope it helps or at least give you an idea.

[HomesickSurfer · Accepted solution]

Hi @Arg0n11 

See attached.  It works, yet I got the sort order of fields reversed.

[Arg0n11]

Thanks! This works as well as the other option provided by @HomesickSurfer.

One follow up though. I see you added the blank columns but how would the solution change if you didn't know the original amount of terms and definitions. So let's say the input was 2 terms and definitions, rather than 3, how would you make it add blank columns to 5 anyway?

[Arg0n11]

Thanks for this. Do you know how to solve the second part of my question with the blank columns?

[ImadZidan]

Hello @Arg0n11 ,

You are correct I am afraid the columns are static and they will have to change if you have additional records.

Please have a look at this workflow. I have adjusted it to construct and pickup the names dynamically.

It will give you an idea that you can expand on.

Let us know if any issues at all. We will always figure something out.