Sorting of similar cell info must transpose like-data from column to row

[kcarth]

Hello, and thanks for having a look at this post. I am looking to create a macro that can transpose like data from columns to a row. Thanks in advance for your response -Kcarth

Example

(before)
1897-00.jpg
1897-1.jpg
1897-2.jpg
1897-4.jpg
1898-00.jpg
1898-1.jpg
1898-2.jpg
1898-3.jpg
1898-4.jpg
1898-5.jpg
1898-6.jpg
1898-7.jpg
1898-8.jpg
1899-00.jpg
1899-1.jpg
1899-2.jpg
1899-3.jpg
1899-4.jpg
1899-5.jpg
1899-6.jpg
1900-00.jpg
1900-1.jpg
1900-2.jpg
1900-3.jpg
1900-4.jpg
1900-5.jpg
1900-6.jpg


(after)
1897-00.jpg 1897-1.jpg 1897-2.jpg 1897-4.jpg
1898-00.jpg 1898-1.jpg 1898-2.jpg 1898-3.jpg 1898-4.jpg 1898-5.jpg 1898-6.jpg 1898-7.jpg 1898-8.jpg
1899-00.jpg 1899-1.jpg 1899-2.jpg 1899-3.jpg 1899-4.jpg 1899-5.jpg 1899-6.jpg
1900-00.jpg 1900-1.jpg 1900-2.jpg 1900-3.jpg 1900-4.jpg 1900-5.jpg 1900-6.jpg

[JBeaucaire]

This could do it:

Please Login or Register  to view this content.

[MickG]

Try this:-
Data sheet1 column "A", Results sheet2.

Please Login or Register  to view this content.

Regards Mick

[jindon]

See if this works on Mac...
Assuming your data in col.A and starts from A1

Please Login or Register  to view this content.

[kcarth]

Thanks JBeaucaire! According to our sample it, it worked perfectly! However, when dealing with characters and numbers there were discrepancies. If the filename started with ee then it didnt sort properly. The same was true for EE. It seems there is a problem with mixing characters and also a case sensitivity issue. I apologize for not giving an accurate example to begin with.

Screen Shot 2015-06-29 at 12.54.51 PM.png
Screen Shot 2015-06-29 at 12.43.15 PM.png

[kcarth]

Also Thank you Mick and jindon

Jindon - for yours we got a run time error '92'
Mick - yours we got a run time error '429'

Thank you for your help on these

[jindon]

OK, it is working on windows though...

This should work.

Please Login or Register  to view this content.

[JBeaucaire]

Correction to my macro using whatever string exists up the first "-" for the match string.

Please Login or Register  to view this content.

[MickG]

Thanks for the reply. I'm sorry ,I did not see your computer is a "Mac", which my code will not work on,Hopefully you have another solution that works !!!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Places results in Column C.

[karedog]

Hi,

Using collection object :

Please Login or Register  to view this content.

Regards