rearrange table by script

Question

I am new to the script.

I have a table like this:

Last nameFrist nameItemsValueWayneBruceAge35WayneBruceHeight180WayneAliceAge23WayneAliceHeight172PakerJohnAge19PakerPeterAge25PakerJohnHeight185PakerPeterHeight178

And would like to convert it to this format:

Last nameFrist nameAgeHeightWayneBruce35180WayneAlice23172PakerJohn19185PakerPeter25178

I can successfully do this by using jmp subset-> rename column name -> update (with matching column) from table menu. Could someone help for the script, if assuming the data set has uncertain number of people and uncertain number of items?

Thanks a lot!

Thierry_S · Accepted Answer

It may not be exactly what you are looking for but have you tried the Split Table feature? It is much faster than the rather convoluted method you described.
Here is how to use it: 1) split column: Value; 2) Split by: Items; 3) Grouping: First Name; Keep All Columns

txnelson · Accepted Answer

This is a simple table Split
     Tables==>Split
Use Item as the Split By column,
Value as the Split Columns
and Last Name and First Name as the Group columns.
Run it interactively, and then go to the output table and edit the source entry and you will see the script to use to implement it in JSL

Jeff_Perkinson · Accepted Answer

Tables -> Split will do exactly what you're looking for.

After putting your columns in the dialog and clicking OK. You'll find a Source script in the resulting data table.

Right click on the Source script and choose Edit to see the script to reproduce the split.