Rearranging Data

N

NerdYorker

Hi,

I have 51 numbers in a row that I want to efficiently rearrange int
columns in groups of three.

EXAMPLE DATA

Current arrangement: 1 2 3 4 5 6 7 8 9

Desired arrangement:
123
456
789


I have over 300 rows that are arranged like this and a total of 5
columns.

I tried TRANSPOSE but I am not sure that is the best method. Any help i
greatly appreciated!

Thank You
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for multiple rows of same value... 2
Count Unique accross mulitple columns 7
Arriving at totals 2
Duplicates-to id when occurs in 3 columns for unique dup in 4th co 1
Data Matching 1
Conditional Formatting from a group 6
Hlookup 3 criteria?? 0
EXCEL 2000 SINGLE COLUMN OF NUMBERS BREAK INTO MANY COLUMNS 4

Top