Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine 2 rows into 1 record
I have a worksheet like this:
(row 1 ) custome_name account_no time_on (row 2) time_off phone_no there are several hundred of additional rows following . I need to combine each set of 2 rows into 1 row/record to be sorted. what I want: (row 1) custome_name account_no time_on time_off phone_no Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine 2 rows into 1 record
So odd number rows have columns A:C populated and even numbered rows have
columns A:B populated?? If yes, I'd put this in D1: =IF(MOD(ROW(),2)=1,"keep","delete") Then this in E1: =IF($D1="keep",A2,"") And this in F1: =IF($D1="keep",B2,"") Now drag these three formula cells down the columns. Select D:F Edit|copy Edit|paste special|values Select column D data|filter|autofilter filter to show "delete" Delete those visible rows data|Filter|autofilter (to remove the filter) GreenPower wrote: I have a worksheet like this: (row 1 ) custome_name account_no time_on (row 2) time_off phone_no there are several hundred of additional rows following . I need to combine each set of 2 rows into 1 row/record to be sorted. what I want: (row 1) custome_name account_no time_on time_off phone_no Can anyone help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import txt file with multiple rows for each record | Excel Discussion (Misc queries) | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
How do I combine rows, combining duplicates as well as concatenati | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |