Merging columns?

  • Thread starter Thread starter Carolina78703
  • Start date Start date
C

Carolina78703

::Hello, Frank-- or anyone else available to help.

How do I merge multiple columns into rows stacked on each other.

Specifically, I have contact info with the categories across th
top/columns and 180 individuals' contact info is placed in rows. So I'
like to sort of merge the data for each person so that it shows up in
more directory look and not a chart format.

Does this make sense?

TIA
Carol:
 
Are there the same number of rows for each person? If so, you can do it with
formulas. If not, you need a VBA macro. For that you need to tell us how you
know that the data for one person has been completed and you are starting
another person. Is there a blank row between entries?
 

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

sorting two columns of merged cells 1
Mail Merge Problem 1
Sharing workbooks limitations - Merged Cells 12
Mail Merge Functionality 1
Can't use protection options 1
merging spreadsheets 2
AutoFilter column w/merged cells 2
Weird Merge question 1

Back
Top