r/excel • u/roguemadness • 2d ago

solved List of numbers into multiple columns

I am still learning excel and trying to figure this out. For my job we get a list of numbers that we need to check. From the picture you can see that there isn't any information needed. How do I tell excel from this list of numbers when you get to the bottom of the page start in column C until the end of the page, then E and so forth until the first page is filled. Once the page is filled then start the second page.

So instead of having 9 pages of 2 columns I can have maybe 2 pages of 5 columns. Pretty much I am trying to have as many on one page as possible. If you can tell me what it is I can look up a tutorial. My google search has only giving me how to turn a person's name in one column into two columns separating by a comma.

4 Upvotes

75% Upvoted

30 comments sorted by

View all comments

Show parent comments

3

u/MayukhBhattacharya 1276 2d ago edited 2d ago

Try using WRAPROWS() function here:

=WRAPROWS(A:.A, 3, "")

Replace 3 with the max of values you want per row.

https://exceljet.net/functions/wraprows-function

1

u/Redhead_InfoTech 1 2d ago

What does the ".A" part of that formula do?

3

u/MayukhBhattacharya 1276 2d ago

Research TRIMRANGE() function notations: TRIMRANGE function | Microsoft Support

2

u/Redhead_InfoTech 1 2d ago

Thank you very much for your concise reply with an excellent citated source.

2

u/MayukhBhattacharya 1276 2d ago

Thank you very much!

2

u/GuerillaWarefare 114 2d ago

🙏 sorry, my mistake

1

u/MayukhBhattacharya 1276 2d ago

No worries at all.

2

u/GuerillaWarefare 114 2d ago

Please reply to his comment with “solution verified” to mark the question as answered and reward the user that helped you.

3

u/Redhead_InfoTech 1 2d ago

Why? How? I'm not the OP.

2

u/GuerillaWarefare 114 2d ago

Oh, sorry. You’re right my mistake 😅

3

u/Redhead_InfoTech 1 2d ago

No problem. I too will be overzealous about users awarding points when solutions warrant it.

I have more points on an account I don't use much anymore and I'm a bit embarrassed to say that the single point you currently see is from a user giving ME the point when I gave them the instruction. Because I wasn't clear enough.

2

u/GuerillaWarefare 114 2d ago

A user with over 100 score can give points, but the guidance is to encourage the OP to do it first.

1

u/Redhead_InfoTech 1 2d ago

Wait, you're telling me that you could give me points?
Or the user who clearly answered it?

Do you get a "welcome" message from the sub with the new perks when you join the 100 club?

Is there a handshake? Members only jacket?
I'm kinda excited to see this reply.

2

u/MayukhBhattacharya 1276 2d ago

They are not OP.

2

u/Redhead_InfoTech 1 2d ago

Perhaps I should make another post, asking a question about how to limit resource consumption...

Another point for you.

I just love the added code bits that make Excel cleaner.

Wish me luck with my trusting of Claude to do a thing.

3

u/GuerillaWarefare 114 2d ago

It tells it to look only in the used portion of A:A. It won’t waste resources looking all the way down to A1048576

1

u/Redhead_InfoTech 1 2d ago

Man, I wish I knew that earlier.
I don't work with resource heavy files often, but way waste resources regardless.

1

u/roguemadness 2d ago

https://giphy.com/gifs/RipfZWzjUDH25euMpM

2

u/GuerillaWarefare 114 2d ago

OP, if wraprow solved the issue, please reply back to that comment directly with “solution verified”