Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have this information (each is on its own row, but in the same cell column):

A, B, C, D
A, C, D
A, D
B, C, D

I want it to look like this (in separated columns, labeled "A" "B" "C" "D"):

A  B  C  D (<column header row)
A  B  C  D
A     C  D
A        D
   B  C  D

Hopefully my illustration makes sense.

How can I do this?

share|improve this question

use the text to column feature of Excel 2010. The feature is located under the data ribbon --> Data Tools --> Text to Columns.

Highlight the data, select the feature and walk through the screens. Here are the screen shots.Location of Text to Columns feature in Excel 2010 Ribbon

Text to Columns Screen Shot 1

Text to Columns Screen Shot 2

Text to Columns Screen Shot 3

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .