Macro to resolve a logic query

Hi,

I am not sure if it is possible, but I want to create a macro that will resolve the following logic query:

Data Table:
01.png

Rules:
1 DataTable starts from Column A to Column L
2 Result Table has 4 Columns + 1 Column (ID) - we start inputting data in Row 2
3 Each ID starts with Column A-B (in White) + Next 2 Unused Columns until all 4 columns are filled before going to next Row
4 The ID is done once there is a Blank Cell or If Reached Column L
5 A Blank Row will be added after completion of each ID

Result Table:
02.png

I want to post the result in Sheet 2. Following the above logic, if I add more data (after Row 4), it should populate the correct and next data in the Result Table.

Any idea how to resolve this?

Logic Table.xlsx

This should do

Please Login or Register  to view this content.

Simply amazing! Thanks! :D

I am trying to decode your array, but do not understand it

Can you please elaborate so I can learn from it?

Thanks

1) Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

2) Which line(s) do you not understand?

Originally Posted by jindon

2) Which line(s) do you not understand?

Mind to comments on the whole code? I am not familiar with Ubound and this might make me friend with it.

Thanks

If you don't understand the code.

Google

1) vba array
2) vba jagged array

3) Do a step debug.
While you are in vbe [View] - [Local Window]
Click somewhere on the code and Hit F8.
As you hit F8, you will see all the variables in Local Window.
Expand the array variable which the have "+" sign and you will see what is actually doing.