Forum Discussion
Transposing data to set columns
Hello,
I'm trying to find a way of achieiving the following -
Data that I import into excel is presented in the following way, the headings will stay the same.
The rows of data will continue to grow each import.
I want to 'transpose' the data to an existing sheet which has the same names but they increase to 30, each new Name, email etc will have a number adding until 30
I need Colum A to be left empty so the first Name will be in column B.
Many thanks,
Lou
the emails included are my test emails.
7 Replies
I want to 'transpose' the data to an existing sheet which has the same names but they increase to 30, each new Name, email etc will have a number adding until 30
I hope you don't mind a question instead of an answer.
The question: WHY?
In general, Excel works far more smoothly when this kind of data are arranged as a single table. Your starting array is a good example.
What is the bigger picture here? Why (there's that question again) do you want (that was your word; not "need") to transpose the data into a long line of repeating instances of the same categories of data? What will that accomplish for you? What's the purpose being served?
Hi mathetes
thanks for the response.
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.
thanks,
Lou
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.)
