I am working on an excel spreadsheet that has data in 17 columns. Some of these columns, say column AJ, contain multiple dates on each line (ALT-Enter) within the cell. Suppose cell A and B contain only one entry, like name and phone number for a person, which are attributed to all lines in AJ.

In other words, I want the code to do the following:

ttt.jpg

Please note that the number of lines (dates) differ across the data so the code needs to figure out how many dates there are and create new rows accordingly.

Any help is greatly appreciated!