Hi,

I have a program that outputs columns of data in a fairly ugly way.

I have a tidy sheet, but I don't want my staff to have to copy and paste each column individually between the ugly sheet and the presentable one.

I want to set up my presentable sheet so that it will automatically copy from the ugly sheet. The problem I have is that the number of entries in the column in the ugly sheet is variable. Sometimes it could be 1000 rows in the column, sometimes it could be 10. So I need a function that will copy from the top to the bottom of the data regardless of how many rows there are.