You have to transpose the fields Program Attended 1, Program Attended 2, Program Attended 3, Program Attended 4, Program Attended 5. See the workbook(version 9.2)

Feel free to ask if you've any query.

Mahfooj

How did you transpose the fields.  Did you do it in Excel? 

Once you connect your data in tableau. In the data source grid pane your can select your fields and right click and select pivot. Go through the link for more detail about pivot in tableau. If this answer your question then close the thread so that It may help others. This thread is opened since last three months so try to close it.

Pivot Data (from Columns to Rows)

Mahfooj

I dont get the pivot option for some reason?

Hi Margarita,

what version of Tableau are you using and what is your datasource?

If you are using Tableau version prior to 9.0 or you are connecting to a database source then the pivot option will not be available.

The pivot option is only available to file based sources, e.g. txt, csv or excel.

Are you using Legacy connection? Take a look first whether its "Connected to Excel (Legacy)". If so then re-create your connection and be sure not to select the legacy option and you should be able to pivot fine.

Differences between Legacy and Default Excel and Text File Connections | Tableau Software

I was trying to do it with a server connection. Looks like it's only available for excel.  Thanks!

Yeah pivot option is only for excel and text files.