6 Replies Latest reply on Nov 19, 2018 3:39 AM by Ombir Rathee

    Data Restructuring using Tableau

    MUHAMMAD MAHMOD

      Hi Tableau Community,

      i want to manage my data using tableau. below is my data.

      Paper NumbSpeaker 1 NameSpeaker 1 CountrySpeaker 2 NameSpeaker 2 CountrySpeaker 3 NameSpeaker 3 CountryChair 1 NameChair 1 CountrChair 2 NameChair 2 Country
      Paper 1AliMalaysiaBurhanChinaDaudBrazilDollahUAEZikriPakistan
      Paper 2AbuMalaysiaBashahIndiaEmiliaUSFaridVietnamAdliPakistan
      Paper 3ArifMalaysiaBrentUSEmySingaporeFuadIndiaHarunBrazil

       

         

      i want to restructure above table to below structure.

       

      Paper NumbRoleNameCountry
      Paper 1Speaker 1AliMalaysia
      Paper 1Speaker 2BurhanChina
      Paper 1Speaker 3DaudBrazil
      Paper 1Chair 1DollahUAE
      Paper 1Chair 2ZikriPakistan
      Paper 2Speaker 1AbuMalaysia
      Paper 2Speaker 2BashahIndia
      Paper 2Speaker 3EmiliaUS
      Paper 2Chair 1FaridVietnam
      Paper 2Chair 2AdliPakistan
      Paper 3Speaker 1ArifMalaysia
      Paper 3Speaker 2BrentUS
      Paper 3Speaker 3EmySingapore
      Paper 3Chair 1FuadIndia
      Paper 3Chair 2HarunBrazil

       

       

      appreciate if somebody can help me.