Concatenate? Add? Joining cells in Excel so as to replace cells that don't line up. 1

[jlockley]

I have an account download with unaligned cells. Row numbers 72-75 will have a single date cell, but the transaction description in the next column is divided into two or three rows, the date may be one full height column or two or three. You can see it in the attachment better than I can describe it.

I need to get this cattywampus mess organized to a point where I can sort the data. I hope someone has an idea better than what I am doing now.

I have inserted a new row and have been concatinating or simply adding the text fields : = C1 & C2 & C3 OR CONCATENATE(C1," ",C2," "C3") OR attempting to Concatenate by dragging cell contents (merge obviously is not an option)

I know there is a way to co this by selecting multiple cells or something like that. I am 1/4 through, and continuing like this I will never finish. Suggestions gratefully accepted.
many thanks.

 

[SkipVought]

Hi,

Select ALL the cells. UNMERGE.

If your DATA begins in row 1, insert a BLANK row above your data.

In the first row of DATA (I assume that's row 2), in TWO COLUMNS TO THE RIGHT of the last column of data (I'm assuming that's column F) and enter this formula:
[tt]
=IF(ISBLANK(A2),F1,A2)
[/tt]

Copy/Paste this formula down through all rows of data and across for the number of columns of data. This should give you a values in every cell corresponding to every row/column of original data.

Finally, SELECT all the cells containing the formula, COPY, then Right-Click in the selection and select PASTE VALUES from the in-cell Drop Down.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[jlockley]

thank you very much.