Originally Posted by Dougie13

I have data in columns A through to J (i.e. 10 columns) and rows 1 to 400. So there is a huge block of data. I need to purely move the data in columns B to J (in sequence) so they sit under just one column A.

In other words I will have a long column A comprising of the same data but all in one column, which will end up being 4000 rows long.

I wondered if there was a quick way to do this? I have no experience of scripts or anything like that so would appreciate a dummies approach to this.

Thanks