Hi there,
I am looking to have a column created with all the Sundays in a year, however not every month has four Sunday's so I have 3 or 4 rows with five pieces of information. Is there a way I can convert a table to columns (I normally use transpose), but this does not move them into one column and there would be blanks.
Thanks,
Bookmarks