0
I have a large (over 10k rows) spreadsheet with text data I want to concatenate from multiple rows into a single row. The text data corresponds to a date that is in a merged cell in a neighboring column, however the corresponding text associated to a specific date is listed in various numbers of rows. I cannot figure out how to write a code that will take into account the varying number of rows.
I tried the macro in the link below, but with the entire project it gives me the following error: Run-time error '13': Type mismatch
It will work if I break it up into small chunks, but even then it might work in maybe one in ten tries.
I have screen shots, but it won't let me post the images without rep points
Macro to merge cells in a column if the same rows are merged in a different column
Share your screenshots using a free img host and post the links. Then a user with high rep will do a suggested edit to add the pictures. – Chrismas007 – 2014-12-31T19:54:54.290
Where does the error occur? What do you think the error means? Is there a pattern to where the data you want to concatenate resides? – Dave – 2015-01-07T08:52:02.980