New member needs help with rows and columns

[ROHfan]

New to the forum here, and kinda new to Excel. I know some very basic stuff and my new position requires me to know a lot more than I do.

Anyway, I've been searching online and haven't found an answer to this problem. I have one row, many cells long, that need to be put into columns.

What I have now (of course, there's data in the cells, all three-digit values):
A1 B1 C1 D1 E1 F1 G1 H1 I1, etc. (The cells go from A1 to DD1--108 cells total).

What I need:
A1 B1 C1
D1 E1 F1
G1 H1 I1
etc.


I've never used macros so is there an easy formula I can apply to achieve the above? Thanks mucho in advance!

Billy

[Glenn Kennedy]

Hi there. welcome aboard.

Regarding your Q... Yes there is. try this out...

[sktneer]

Another approach...

If your data is in Row 1, try this.....

Please Login or Register  to view this content.

and then copy across to next two cells and down as far as needed.

[ROHfan]

Hi there. welcome aboard.

Regarding your Q... Yes there is. try this out...

Thanks so much! Worked like a charm. That file just saved me about three hours a day. Wish I could contribute something to this board but, like I said, I'm new. However, if anyone here needs any Home Theater or 2 Channel Audio advice, hit me up. Or car detailing advice. And smoking meats.

[Glenn Kennedy]

Ha Ha... It took me a long time before I started (cautiously) to offer solutions to others.
If you're happy enough with the solution, please mark the thread as solved and, maybe, say thanks to all who helped by clicking on the add Reputation button at the foot of their post(s).

[ROHfan]

Ha Ha... It took me a long time before I started (cautiously) to offer solutions to others.
If you're happy enough with the solution, please mark the thread as solved and, maybe, say thanks to all who helped by clicking on the add Reputation button at the foot of their post(s).

With pleasure, and DONE!

[Glenn Kennedy]

Thank you!!