Forum Discussion

Aachisuto's avatar
Aachisuto
Copper Contributor
Aug 11, 2022

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. Ideally, it would be nice for Word to reference Excel, but I will just be happy if I can simply change the column into a table in Excel that I can copy and paste into Word. I tried highlighting all the cells in the table in Word and pasting the data from the column, but it just repeats the date across the entire row. 

  

^  List of dates for example (they won't be everyday like this though)

 

Pasting into the cells gets me this   V

 

This is how I want the list of dates to be arranged. 

I am going to be needing to do reports that have dates listed like this on a lot of info so that is why I am trying to figure out how to rearrange the info automatically so I don't have to retype everything every single time. I would appreciate any help!

6 Replies

Resources