Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Spreadsheet Software
  6. / Microsoft Excel

by lepeknedle on July 23rd, 2009

lepeknedle

Question

Help answer this question below.

Would anyone be able to assist on how to separate numbers into unique columns in Excel An example of the data is:

1, 3, 6, 9
3, 7, 9, 10
and so on...

So, number '1' would go into the column for '1', '3' would go into the column for '3'...

  • Like
  • Report
Share:
Other

Answers. 1 helpful answer below.

  • by Cyanotic Wasp on July 24th, 2009

    Cyanotic Wasp

    I'm sure there's any number of ways to assist you with this, but how are we supposed to do that? What's the form of your data, a comma-separated list as you show, a column of values, or what? Are they all positive integers between 1 and 256? How long is the list? How much duplication of values should we expect?

    And these are just the first few questions that occur to me. I'm sure that I'd have more.

    I guess my first question of all is, "What's the purpose of this, anyway?" I can't see any basis for why you'd need to do this particular sort; let us know what your final objective is, and maybe we can get you there a better way than you're now thinking.

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading Would anyone be able to assist on how to separate numbers into unique columns in Excel An example of the data is: 1, 3, 6, 9 3, 7, 9, 10 and so on... So, number '1' would go into the column for '1', '3' would go into the column for '3'...

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Where are venus flytraps native

Answerbag

a Demand Media company