Turn data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list that is in Excel, but was sent to me without a header row.
Instead, Column A lists what data should be in the header, repeated for each
entry. Aside from the copy paste special, and transpose command, is there any
way that I can change the data to appear as in rows versus two columns?
 
If you exclude the transpose command, as you did, a VBA solution would be
required. But more detail about your data layout would be needed for
someone to come up with the VBA code you would need. If you wish, send me,
direct, your file, or a sample of it. Include in this file a small sample
of what you want the layout of the data to look like. My email address is
(e-mail address removed). Remove "nop" from this address. HTH Otto
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to transpose data (Row to column) without losing the cell link 3
Splitting a cell into rows instead of columns 12
Transpose, but how? 0
repeating macro 2
Display index of column headers in column A 9
transposing data 3
How do I sum a column based on 2 different column headers/criteria? 0

Back
Top