| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting one column into multiple columns
I have a column of text (non-numeric) data that I want to split into
multiple columns whenever the same text appears. What I mean is: I have: Title Info1 Info2 Info3 Info4 Title Info5 Info6 Info7 Info8 Title Info9 I want to change that to: Title Title Title Info1 Info5 Info9 Info2 Info6 Info3 Info7 Info4 Info8 Ultimately, I will then delete the lower rows of information straight across the board. Leaving me with: Title Title Title Info1 Info5 Info9 Info2 Info6 The "title" is always the same phrase/content. Is there a macro or VBA code I can use to accomplish this? Thanks in advance, PM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move list of numbers from one column to multiple columns | Excel Discussion (Misc queries) | |||
| combining multiple columns into one column - enhancements | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| spliting a column of data into multiple columns | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Threaded Mode
