Thread: Combining rows
View Single Post
  #1   Report Post  
SteveRJ
 
Posts: n/a
Default 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