convert row columns in different columns

• Ayie

  SSC Eights!

  Points: 828

  More actions

  July 27, 2011 at 3:19 am

  #254354

  Hi,

  Please help me to create a query to segregate the row columns in multiple columns.

  Here is my problem

  Page_Path

  /zh/destinations/turkey/istanbul/vakkorama/

  Results:

  Column 1 Column 2 Column3 Column 4 Column 5

  zh destinations turkey istanbul vakkorama

  Please help me to create a query for this.

  Thank you

  Ayie

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  July 27, 2011 at 3:30 am

  #1359026

  Ayie

  Please search this site for "splitter function". Jeff Moden has written a number of articles that comprehensively cover what you're trying to do.

  John