LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sorting and lining up data into columns based off content

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lining up 2 columns of zip codes JSpence2003 Excel Discussion (Misc queries) 1 July 5th 07 05:02 PM
Data lining up correctly when printing Brad Excel Discussion (Misc queries) 0 December 19th 06 08:33 PM
Change the data in one cell based on content of another. Barry Excel Discussion (Misc queries) 2 September 3rd 06 08:26 AM
Lining up data from concatenation Some Dude Excel Discussion (Misc queries) 10 June 5th 06 07:28 PM
Extracting data based on content loopkid1 Excel Discussion (Misc queries) 5 March 7th 06 03:08 PM


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"