Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.