Excel Import data to two sets of columns

I have an excel sheet set up to import data from a SQL database. This works fine. The data looks like below.
AAAAA BBBBB CCCCC
111111 22222 333333      
222223 54353 456453
333243 23432 423423
About 40 rows of data

Open in new window


What i want to do is is import the data into two sets of columns. Like below
AAAAA BBBBB CCCCC   AAAAA BBBBB CCCCC
111111 22222 333333  447475 43543 345435      
222223 54353 456453  435343 34555 353533
333243 23432 423423  435553 34543 34543

Open in new window



Once the import gets to row 20 it starts importing into the next column. I am sure Excel can do this but dont know the right word to search for on google.

Any help would be great.
LVL 1
Daniel_P67Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Robberbaron (robr)Commented:
only way i could do it was 2 queries, each returning 20 rows.

or reformat data after import using vba. this is the way i would do it, but only because im more comfortable.

 and what happens  if more than 40 records are available.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Daniel_P67Author Commented:
Thanks, be too easy the other way. We just had two queries and display them side by side.
0
Daniel_P67Author Commented:
Was looking for the imposable. This was the best way.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.