Istudent Rana

Istudent Rana

  • 1.1k
  • 316
  • 79.6k

Pivot table and insert the data into table

Apr 30 2019 1:51 AM
This is my situation, 
 
my data in the table is like this
 
mailnumber  type email
 1  inbox  some inbox message..
 1  sent     some sent message..
 2  inbox     inbox message
 2  sent     sent message
 
What do i want to achieve is that I want to pivot this data into
 
 mailnumber    inboxMessage  SentMessage
 1  some inbox message..  some sent message..
 2  inbox message  sent message
 
and insert the data into new table
 

Answers (3)