Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have imported a large group of data and would like to sort it into some
sort of order. Each row has 20-30 cells of data. All of the data is in the same order, but some of the rows are lacking some of the cells of data. I'd like to line up all the same types of data and insert either a blank cell or a "n/a" type value into the rows in the proper spot to align the data. I guess the best way is to give an example. Here's the data I have: Name | Address | Phone | B-Day | Name | Phone | B-Day | Name | Address | B-Day | Here's what I want to end up with: Name | Address | Phone | B-Day | Name | --------- | Phone | B-Day | Name | Address | ------- | B-Day | Each of the different types of data are identifiable based off the first part of the string. For example, all address cells start with "Address: " and all the phone cells start with "Phone: ". Thanks for the help in advance ^_^ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lining up 2 columns of zip codes | Excel Discussion (Misc queries) | |||
Data lining up correctly when printing | Excel Discussion (Misc queries) | |||
Change the data in one cell based on content of another. | Excel Discussion (Misc queries) | |||
Lining up data from concatenation | Excel Discussion (Misc queries) | |||
Extracting data based on content | Excel Discussion (Misc queries) |