Trying to Flatten a table

Question

I am trying to flatten this table. I've seen other posts about it, but can't seem to put the pieces together.

Below is the table that I'm trying to flatten and have it create a new column dynamically for the result date and result

IDResult DateResult1050511/20/202481050512/13/20247.91057009/1/20239.410570010/13/20238.61057001/12/20246.910600911/8/20239.91060093/3/20248.41060093/4/20248.410626910/5/20235.71062694/3/20246.21062774/11/20245.41062774/12/20245.410637011/10/202310.110637012/5/20238.21063703/12/20245.9

This is what I want to create, with the dates going in ascending order.

IDResult DateResultResult DateResultResult DateResultResult DateResult1050511/20/202482/13/20247.9    1057009/1/20239.410/13/20238.61/12/20246.9  10600911/8/20239.93/3/20248.43/4/20248.410/5/20235.710626910/5/20235.74/3/20246.2    1062774/11/20245.44/12/20245.4    10637011/10/202310.112/5/20238.23/12/20245.9

Any insight would be helpful!!

Thanks

Luke_C · Accepted Answer

Hi @SM66215

Column names have to be unique, but the workflow would be something like this:

* Transpose
* Number the records within each ID
* Crosstab back out