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

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

CrossTab.yxmd