Trying this again - with more understanding of the process and what works best for the experts.
I have a table, two columns per name, Column A is the name field, and column B is the test completed. There can be 1 or more row per name, but this does vary. The number of Tests indicated in Column B can also vary.
Col A/B Col C
Row 1: F/L Name 1 Test 1
Row 2: F/L Name 1 Test 2
Row 3: F/L Name 2 Test 1
Row 3 F/L Name 2 Test 3
Row 4: F/L Name 2 Test 4
Please offer how I can change this format so that there is only one row per name, where Column B is turned into multiple columns depending on the # of tests. In the example above
Col A/B Column C Column D Column E Column F
Row 1 is now F/L Name 1: Test 1 Test 2
Row 2 is now F/L Name 2: Test 1 Test 3 Test 4
I have tried variations of transpose without success.
Hope this makes sense to you.