Excel 2007 : Import SQL query, results on both side of the pages

[PacinoQS]

Hey,

I am trying to import an SQL query into an Excel worksheet.

Everything works fine, only problem is that it is a very long list and only the left side of the page is used, the whole right side of the page is empty.

I am looking for a solution so the list will go first from the left side of the page to the bottom, and then instead of going to the next page, it should fill the right side of the page to the the bottom.

At the moment it looks like this:
<name> <telnr>.................................| end page

Desired result:

<name> <telnr>................<name> <telnr> ..| end page

Is this possible? I searched a long time for a solution but I cant find a decent one.

Thanks in advance.

 

[PacinoQS]

I am sorry, b2 is c1, i typed it wrong.

This is the formula with replacement:

=INDEX(assortiment_excel,MOD((ROW()-1),ReportRows)+INT((ROW()-1)/ReportRows)*ReportRows*ReportCols+INT((COLUMN()-1)/SourceCols)*ReportRows+1,MOD(COLUMN()-1,SourceCols)+1)

I have no idea why it works for you but not for me.

 

[SkipVought]

did you change 2 sourcecols to 3?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[PacinoQS]

Yes I did but it just isnt working. Are you sure the formula is correct?

 

[SkipVought]

Please explain HOW it is not working.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}