Forum Discussion
Convert single column of data into spread out table format for a printed report
I have hunted everywhere for the answer to what I thought was a simple problem. I am trying to take a list of dates and rearranging them into a table so it can be better organized for printed reports...
It did.. something? Lol. I think it corresponds to the dates somehow. I used the actual data from my report this time so it starts 4/1/22 then goes 4/4/22 and on.
Looks good. Format the cells as dates and you're set.
- Aah I see. The formatting already on those cells wasn't recognizing the numbers as dates. Thanks!
Last question. In the formula you gave, i get that 4 means rows and 7 means columns but what do the 1's mean?- Thanks!
