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 |
