Forum Discussion
Create a new table from existing data in another table
I want to create a new table but use the unique values in an existing table column as the column headers for the new table and then pull over the values (dates) associated with the values of the head...
This is what the sample table looks like now:
This is what I want the new table to look like:
lbendlin
Super User
Super UserThat looks straightforward. Use a Matrix visual. Put the Order # in the rows. Put the Name in the Columns, Put the End Date in the values.
Yes, thank you. I need it to be in an actual data table so that I can add a calculated column to calculate different SLAs. So for instance:
Sorry, I should have included that info, but all I need is to know how to create a new table from this existing data and then I can do the rest of the calculations.