Split Single Row into multiple rows based on column data

I need to modify raw data that is pulled from online submissions. The data is for tournament entries that can have a single person up to a team of 3 that exports all to one line. Entries with 2 or 3 participants need to be cut and inserted into rows below the active row. I found code that works properly for data in Col U-AF but pastes data from Col AG-AR wrong (code pasted below).

• The number of rows for the original raw data will vary.
• Each row will always have data in Col A-T.
• The length of each row will contain data for 1 to 3 people.
• Participants 2 & 3 need to be pasted on new rows starting at col F.

Example:

1. If column U-AF contains data then:

(1) Insert ONE row below
(2) Cut/Paste data from col U-AF into NEW row starting at col F.

2. If there is no data in col U then move to next column.
3. If col U-AR contains data then:

(1) Insert TWO rows below.
(2) Cut/Paste data from Col U-AF in the FIRST NEW row.
(3) Cut/Paste data from Col AG-AR in the SECOND NEW row.

Please Login or Register  to view this content.

See if this works for you.

Please Login or Register  to view this content.

It worked on every row but the first (row 2). There is still data in columns after T. Is there any way to fix that?

Here is a snap of what it was doing. Forum - Tourney Snap.jpg

I was basing the source range on the code in post #1 where it indicates that source data begins in row 3. Is that incorrect? According to the screen shot in post #3 , row 1 and 2 are header rows and data begins in row 3, so the code should be returning any data found in row 3 on an inserted row if it exceeds the 21 cell limit.