How to convert multiple rows inot a column

E

Elizabeth

I have an excel file with hundreds records.
Colum D
A15 MC1150
A16 MA1500
A17 CR1100
A18 CM2100
A19 CP1310
A20 CP2190
How to put these rows into a column E
Column E
MC1150; MA1500; CR1100; CM2100;
CP1310; CP2190
Thanks!
 
J

JE McGimpsey

Elizabeth said:
I have an excel file with hundreds records.
Colum D
A15 MC1150
A16 MA1500
A17 CR1100
A18 CM2100
A19 CP1310
A20 CP2190
How to put these rows into a column E
Column E
MC1150; MA1500; CR1100; CM2100;
CP1310; CP2190
Click to expand...


A little more info is in order...

Should ALL records in column D be concatenated into Column E?

or only 6 in row 1, the next 6 in row 2, etc...

Also, it's always best to indicate which version of Mac XL you're using.
 

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

Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Autofill cells in 1 column :code ?? 2
Creating Serial Additions of Numbers Formatted "M-N" In Merged and Unmerged Cells 2
creating multiple worksheets from one 0
Convert multiple columns into a single row 2
Copy down (propagate) function/forumula needed 4
sum if 1
End(xlDown) giving me blanks 1

Top