| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Columns to Rows based upon a duplicate value
I have columnar data in the four headings below;
A B C D Loan Number / Taxpayer ID Number / Customer Name / SCR21 It is possible that there is information for two customer four each loan. Is there a way for my to compare the values in the "Loan Number" column in rows 3 and 2, and if it matches the cell above, copy the contents for columns B, C & D and paste the to Columns E, F & G in row # 2? Thanks for any help, EJR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Marking duplicate entries based on multiple columns | Excel Discussion (Misc queries) | |||
| find duplicate based on two columns | Excel Discussion (Misc queries) | |||
| Automatically Duplicate Rows based on Volume. | Excel Worksheet Functions | |||
| Duplicate rows, based on date difference | Excel Programming | |||
| Duplicate rows based on date difference | Excel Programming | |||
Threaded Mode
