How do I transpose entries that repeat in sequence down a column .

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

Guest

I am trying to transpose a bunch of data that is repeated ad nauseam down a
column (lets say Column A) and I want to separate the entries so that they
appear listed by column:

Example:

Change this data

Bob Smith Name
3 Smith Street Address
03-9898-1214 Phone

Jane Doe Name
4 Big Avenue Address
03-9898-1215 Phone

Into This Data
Name Address Phone
Bob Smith 3 Smith Street 03-9898-1214
Jane Doe 4 Big Avenue 03-9898-1215
 
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

Rows To Columns & Hyperlink to Email Address 0
Excel Macro to transpose addresses from rows to columns 3
Combine multiple columns and rows for one record into one row. 2
Transfer data from Excel col. A to columns B-E in the same sheet 3
Count how many instances of an item appear in a range 2
Transpose Based on Criteria 9
How do I transfer repeating info in a column to 3 rows? 7
How do I compare two sheets and output a report? 2

Back
Top