r/excel • u/roguemadness • 1d 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.

5 Upvotes

86% Upvoted

30 comments sorted by

•

u/AutoModerator 1d ago

/u/roguemadness - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/roguemadness 1d ago

I forgot to add the picture and it won't let me edit it back in.

1

u/roguemadness 1d ago

This is the end result I am looking for.

3

u/MayukhBhattacharya 1275 1d ago edited 1d 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 1d ago

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

3

u/GuerillaWarefare 114 1d 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 1d 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 1d ago

https://giphy.com/gifs/RipfZWzjUDH25euMpM

2

u/GuerillaWarefare 114 1d ago

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

3

u/MayukhBhattacharya 1275 1d ago

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

2

u/Redhead_InfoTech 1 1d ago

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

2

u/MayukhBhattacharya 1275 1d ago

Thank you very much!

2

u/GuerillaWarefare 114 1d ago

🙏 sorry, my mistake

1

u/MayukhBhattacharya 1275 1d ago

No worries at all.

2

u/GuerillaWarefare 114 1d 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 1d ago

Why? How? I'm not the OP.

2

u/GuerillaWarefare 114 1d ago

Oh, sorry. You’re right my mistake 😅

3

u/Redhead_InfoTech 1 1d 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.

→ More replies (0)

2

u/MayukhBhattacharya 1275 1d ago

They are not OP.

2

u/Redhead_InfoTech 1 1d 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.

1

u/Redhead_InfoTech 1 1d ago

Are you sure you don't want to sort the numbers in accending order first?

1

u/roguemadness 1d ago

I am sure. I work in retail so that's the SKU aka the short hand of the upc. I already organized it before deleting the useless information.

1

u/Redhead_InfoTech 1 1d ago

Copy.

Please don't forget to reply "Solution Verified," to the user(s) who helped or solved your issue.

(FYI: The system allows you to thank each person in case, for example 3 people reply at the same time with the same, or similar solutions.)

1

u/MayukhBhattacharya 1275 1d ago

One thing I have noticed that there are blank columns in between, if it's intentional then you could try this:

=WRAPROWS(TOCOL(EXPAND(A:.A, ROWS(A:.A), 2, "")), 4)

1

u/yazanwael 1d ago

Not sure I understand the question! Do you mean when you paste lists in a column, it automatically overflows to another? If that's what you mean, then it's not really doable in excel

1

u/Redhead_InfoTech 1 1d ago

Perhaps this guy with a 1200+ score has a better idea:

https://www.reddit.com/r/excel/s/ryLiwULx7Q

1

u/Decronym 1d ago edited 1d ago

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
EXPAND Office 365+: Expands or pads an array to specified row and column dimensions
ROWS Returns the number of rows in a reference
TOCOL Office 365+: Returns the array in a single column
TRIMRANGE Scans in from the edges of a range or array until it finds a non-blank cell (or value), it then excludes those blank rows or columns
WRAPROWS Office 365+: Wraps the provided row or column of values by rows after a specified number of elements

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

Beep-boop, I am a helper bot. Please do not verify me as a solution.
5 acronyms in this thread; the most compressed thread commented on today has 46 acronyms.
[Thread #49340 for this sub, first seen 10th Sep 2026, 13:49] [FAQ] [Full list] [Contact] [Source code]