Hi,

I guess I dont know what words to search in the forum, but I'm sure this has been asked: How do I make a 16-by-1 (columns-by-rows) set of data into a 4-by-4 set, or an 8-by-2 set....or a 2-by-8 set for that matter? Or as in the picture, how do I turn the red into blue without retyping it like I did here (a 7-by-1 into a 4-by-2 with a space left over):

Capture.PNG

I'm taking comma-delimited data from a source in one long string, like "1000, 1005, 1006, 1010, A1012, B0001, B0030, ...". So all that goes into cell A1. I can text-to-columns successfully and end up with a single-row of cells A1=1000, B1=1005, etc... But I'm not keen to scrolling way over to the right to see the end of my result, which could be hundreds of cells. I'd rather see the finished product as a block of data on my screen - no scrolling.

Let's say I have 200 cells in a single row. I'd rather see my 200 cells in a convenient 10x20 block, say columns A-J (10 columns) and rows 1-20 = 200 cells. Transpose? Not exactly. Copy-paste-copy-paste-copy-paste...? Yeah - did that, no.

I guess I'm looking for a smart-transpose, and perhaps there's an excel function already built for just that.

Any help would be appreciated.

Thank you.