Hi Everyone,

I'm dealing with an odd data set here that need to be transpose some how,
here is the sample of the data set:

Col A | Col B | Col C | Col D | Col E | Col F |
Col G |
Name | Address | ID# | Line Item # | Item Des | Other1 | Other2 |
John | 123 street | 147 | 1 | s.thing1 | note1.1 |
note1.2 |
(blank)| (blank)| (blank)| 2 | s.thing2 | note2.1 |
note2.2 |
(blank)| (blank)| (blank)| 3 | s.thing3 | note3.1 |
note3.2 |
(blank)| (blank)| (blank)| 4 | s.thing4 | note4.1 |
note4.2 |
SMITH | 369 street | 148 | 1 | s.thing1 | note1.1 |
note1.2 |
(blank)| (blank)| (blank) | 2 | s.thing2 | note2.1 |
note2.2 |
(blank)| (blank)| (blank) | 3 | s.thing3 | note3.1 |
note3.2 |


What I need to do is to get rid of all the blank cell and Transpose the Col
D and E (Line Item # and Item Des) to be in a column format instead.

That problem:
Line item # and Item Des are varies from name to name.
There are Col F and Col G (more than 2 columns) following the Line Item #
and Item Des, which will be overwrite after transpose, if not done correctly.

Does anyone have a solution to this without having to Copy Paste Special
Transpose the data Name by Name Manually? I'm talking about thousands of
record here.

Thank you for any advice or help.

Neon520