Turn rows into column headings on 1 new sheet

[sharahoff]

I am working on separating data and have around 3000 rows of information on a master data sheet. I need to separate the first 3 columns on the master data sheet and put them into the first 3 rows of a single column on 1 new sheet. The separated data should be repeated 6 times with an empty column between each separate entry.

I have attached an example.

Thank you for any help!!

[mike7952]

You will run out of Columns 3000x6=18,000 and thats without adding the spaces. There are only 16,384 Columns. I dont know about 2010 but I think its the same.

[sharahoff]

I can separate the master data onto separate sheets to avoid this. The purpose of my question is just for formatting purposes; tables will be entered under each converted row heading.

[mike7952]

Ok then give this a try

Please Login or Register  to view this content.

[sharahoff]

That worked beautifully! Thank you so much for your time!!!!

[mike7952]

Your welcome