creating table

[whynot]

I would like to create a table with information i have in two columns.

The issue I have is that there are rows that do not have information and i do not want to include that in the table.

The following screenshots illustrate the appearance of the data set and what i would like it to look like.


The current data set

What i would like to create

Really appreciate the help.

 

[Fluff]

How about

+Fluff New.xlsm
	L
1	01/01/1960
2	31/03/1960
3	30/06/1960
4	30/09/1960
5	31/12/1960
6	31/03/1961
7	30/06/1961
8	30/09/1961
9	31/12/1961
10	31/03/1962
Data

Cell Formulas
Range	Formula
L2:L10	L2	=DATE(YEAR(L1),CEILING(MONTH(L1)+1,3)+1,0)

 

[whynot]

Thank you very much for your help!!

I am assuming you must be outside of the U.S. based on the date format you used in your spreadsheet.

 

[Fluff]

Yup, I'm English, hence the avatar

 

[whynot]

Makes sense!!

Been to London many times - need to see other parts of the U.K. one of these days.

Love London - one of my favorite cities.

 

[Fluff]

I'm a country boy & hate big cities. Far prefer the countryside.

 

[whynot]

you are an excel genius - country or city.

I appreciate all the help!!!

 

[Fluff]

Thanks for the kind words.