Sorry about that - See updated attachment - 2 more tabs -
one showing how the copy/paste/transpose should look (Step1)
one showing how the end result would look after the blank lines got deleted along with the no long needed remaining data set rows


UPDATED: NOSPARKS - just saw and added your last block in post #8 and tested it -- to find it appears to be working great!
Awesome!! Thank you, I've run it on the real data and find it's working there too! All of the Inventory in the large data table looks perfect! Thanks again! (and thx Jeffrey for your help too!)


PS - I was wondering how it was going to be written to locate both the extra rows of data (no longer needed) AND the blanks for deletion --
.......I like the simplicity of just looking for blanks in Col B and deleting whole row based on that!

Attached Files

TEST-copy-paste-TRANSPOSE.xlsm (27.9 KB, 8 views)