mail merge excel to word

[ksbigfoot]

I opened up Word and did a mail merge with an excel file.
My word document has 5 columns and 4 rows.
My excel document has 2 rows and 4 columns.
What I am trying to do is put the information from the excel file into columns of the word document.
Does anyone know how this can be done.
Thanks

 

[ksbigfoot]

From trying out different things.
Is there a way in microsoft word to change a table with 2 rows with 5 columns to a table with 5 rows with 2 columns.
Flipping the content from rows to columns?
Thanks

 

[ksbigfoot]

I found out that Microsoft word cannot transpose a table.
My first question is still what I am looking for.
Can I pull data from some source and display it in columns instead of rows?