bushidowarrior
Board Regular
- Joined
- Jun 27, 2011
- Messages
- 84
- Office Version
- 2019
- Platform
- Windows
Hello all.
I have the table located below, but I have to organsise the data in to the format of Fig 2.
Fig 1. the data the is carried over is Column D, G and H
From this (Fig 1)
All the info below come from the above table, as you can see the data is grouped the number is column A.
So, group 1 has only 2 questions whereas group 3 has 3 questions.
I would like it so it can support up to 20 questions on 1 row. The above image should support at least 100 rows.
To this (Fig 2)
I think I have explained it well, but I am not sure.
Thank you all very much.
I have the table located below, but I have to organsise the data in to the format of Fig 2.
Fig 1. the data the is carried over is Column D, G and H
From this (Fig 1)

All the info below come from the above table, as you can see the data is grouped the number is column A.
So, group 1 has only 2 questions whereas group 3 has 3 questions.
I would like it so it can support up to 20 questions on 1 row. The above image should support at least 100 rows.
To this (Fig 2)

I think I have explained it well, but I am not sure.
Thank you all very much.