| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data Filtering
I have 22000 rows of data that are sorted into two columns. column a has 10
rows of address labels, a space, then repeated over and over again. i need to sort this information into 10 columns but don't know how. can anybody help with a formula that will enable me to have column headers of Name address etc and the data filtered correctly "current data" Name 1st Move International Ltd Add1 International House Worthy Road Add2 Chittening Industrial Estate Add3 Chittening Add4 Bristol PC BS11 0YB Tel 0117-982-8123 Fax 0117-982-2229 web www.shipit.co.uk I need it to be like this A B and so on Name Add1 and so on Please help!! -- James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables filtering data | Excel Discussion (Misc queries) | |||
| Filtering data from one worksheet based on another | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
