Separating Text and Dates

[cmohyi]

Hi Community,

I have a data set where the first column contains both identifier and dates like this example:

Fund 1

"Data Point"

2014-03-31

Prior to the rows that have dates and data points relating to those time periods, it always says "Data Point" in the first column. I'd like to split the data into two columns everytime "Data Point" appears. Any ideas?

Thanks in advance!

[BenMoss · Accepted solution]

Hi @cmohyi it sounds like you want something like attached but your sample is too small to build a complete solution without knowing the complete data structure.

Do you want to take a look through this solution and add any problems you have with the solution.

Ben

[cmohyi]

I had to tweak the first multi row formula for it to work, but this is just what I was looking for!! Thank you Ben!!