Consolidate multiple columns data in single column.

[Biker2]

Dear members,

I have excel 2007 sheet as follows:-
<a href="http://www.flickr.com/photos/indianbiker/3945338417/" title="untitled by IndianBiker, on Flickr"><img src="http://farm3.static.flickr.com/2497/3945338417_33bc904ee4.jpg" width="500" height="313" alt="untitled" /></a>

As you can see, Name, Registration, Address, Country, Telephone columns are repeated ... is there any way such that there single column of Name, registration, address, country, telephone and under it there are various data ... like this

<a href="http://www.flickr.com/photos/indianbiker/3946135654/" title="untitled2 by IndianBiker, on Flickr"><img src="http://farm3.static.flickr.com/2472/3946135654_d8a9bcf150.jpg" width="500" height="313" alt="untitled2" /></a>

Any help would be highly appreciated !!

 

[Michaels]

Hello Biker!

I think you should use CUT and PASTE thing. It just takes less than a minute even for thousands of rows.

Secondly, there is no such feature as text consolidation in Excel.

Hope that helps.

 

[Biker2]

Hello Biker!

I think you should use CUT and PASTE thing. It just takes less than a minute even for thousands of rows.

There are nearly thousand entries in a row (with repeated name, registration, country, add, telephone) ... I'll have to copy all those entries and paste paste one below another. That is nearly not feasible.

 

[Michaels]

OK...you mean you have duplicate entries, same name and registration number. For this, you can use advanced filter and unique records.

 

[xenou]

Does every "entry" have exactly 8 cells (A-H; I-P; Q-X; etc. etc.)?