I want to create a table box so that I can then send the data to excel easily, the problem is that I have data coming from different tables via SQL SELECTS and I want to LOAD the data so that I can create an internal table as the source of the table box.
The format of the data is roughly like this, each columns contents are the results of different queries.
I've tried to create a table using the fields already in the LOAD script and get a cartesian product with 000s of rows, and no blank data.
Any ideas on how to achieve this? I want to have spaces where there's no data e.g. Col1 has 1 row, Col2 has 1, Col3 has 4 rows.
I guess I want 5 list boxes linked together so I can then send the data to Excel.