I'm trying to use Excel to reformat a dataset. The dataset has multiple rows of 'items' per 'id' which I want to shift into a single row of multiple columns of 'items' per each 'id'. In addition, I'd like to be able to have 2 groups of columns for the 'items' - see screenshots. As per the example not every 'id' will have the same number of 'items'.

The dummy data shown here illustrates the requirement:

Original data: