Transposing data to set columns

LousQuinn 

I’m currently building a MVP and the excel widget which I use, Uses the headings to import the data. 
So if the spreadsheet was set up with the names and emails et cetera in one column I would only be able to bring in one at a time and I’d like to bring in 30.

My online colleague Riny_van_Eekelen has given you the solution you've requested, leaving me free to restate my question in light of your explanation above. So consider this more of a theoretical or conceptual issue.

Your explanation really surprised me, to be entirely frank. Let me explain why it surprised me. If you were  using Excel as the source database for Mail Merge in Word, you would definitely be using a table with one set of headings and all the different entries lined up vertically. That's inherent in how it works, and works well, with many rows. (I use it to create mailing labels for well over 100 people, for example.) So that you're using some "excel widget" heightens the surprise; I would have expected an excel widget to follow the same pattern for importing the data into your MVP as is used in connecting with Word.

(By the way, if you Google the initials MVP, you find several different meanings. In addition to the sports' use for "most valuable player," there's also "minimal viable product," "MVP Health Care" -- and no doubt other adaptations. I'm assuming you mean the minimal viable product but that's based on nothing solid, and really doesn't matter for our purposes; but you might want to clarify if you use the abbreviation elsewhere with folks not involved in your project.)