Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rearrange info in rows to columns - HELP!
I have a problem and hope someone can help. I am under a MAJOR time crunch, so if you are able to help me, this would be a gigantic time saver. I have an export file in .csv format. It has 2 columns of data, grouped in blocks of 10 rows, but there's a twist - in cell A2 there are multiple items so it looks like what I've entered below - no commas or anything at the end of each line. Each of the other cells that are part of the block in that column only have a single item in them. The cells in column B (rows 1-10) only have single values in them too. I'd love to know if there is a way to sort this with a formula - this is a big file and I'd like to be able to get the data into columns with a formula rather than manually editing each entry. Ideally, it would have the values from the cells in both column a and column b into a single row, but not imperative. Your input would be most appreciated - have to get this file formatted for import into another program by mid-week. LaVerne Cell A1 - Group Cell A2 - Account code Full account name Location File # (sometimes has a 5th and 6th line but most are 4 lines - similar to an address label - need each of these values to have it's own column) Cell A3 - Salesperson Cell A4 - Department Cell A5 - Notes -- LaVerne ------------------------------------------------------------------------ LaVerne's Profile: http://www.excelforum.com/member.php...o&userid=24360 View this thread: http://www.excelforum.com/showthread...hreadid=380676 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to have rows labled A->Z and columns 0->n ? | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) |