| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset function with inconsisent data location
I have been trying to use the offset function, but I guess I don't understand
the functionality enough to customize, so here is the issue. I have one column of data which contains a firm name, address, city, state, zip. I want to move that data from the rows to new columns with those titles, so the data can be used more effectively.The problem is the data is incomplete, so it looks like this: Engineer John Smith <blank <blank Jane Smith <blank <blank <blank <blank John Doe 123 Main St Anywhere, TX 78101 I need to get to: Col1 Col2 Col 3 Engineer Address City,State,Zip I am having difficulty since there is no consistency to the number of blank rows in the original column, but I cannot simply delete them since there is data in those rows in other columns. Does that make sense? Please help, thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| large function result as reference for offset function | Excel Discussion (Misc queries) | |||
| Transposing Data using Offset function | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
| OFFSET function to pick up monthly groups of data | Excel Worksheet Functions | |||
Threaded Mode
