Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining rows
I have 1 row that contains multiple columns with contacts - name, title,
phone, etc. All for the same company. I need to be able to extract that set of columns in the single row and create multiple new rows. For example here is the current row NAME PRESIDENT/CEO TITLE CFO TITLE COO TITLE ABC David Smith President Joe Smith CFO Bill Smith COO And here is what I need to convert it to NAME PRESIDENT/CEO TITLE ABC David Smith President ABC Joe Smith CFO ABC Bill Smith COO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Combining Pivot Tables - Summarising data from 100,000 rows | Excel Discussion (Misc queries) | |||
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 | |||
Adding Rows to Master Sheet | New Users to Excel |