Printing populated rows only

Thank you VERY much for this idea. I tested it on the noblanks file and it worked ideally - and I was hopeful it would solve our problems. However, when I grabbed a limited sampling of the real data (90 rows of 'descriptive labels, and 32 columns of populated data), when I tried to run the macro, I received an error: Too Many! You have exceeded the number of transactions for this column. Exiting system.

When I check the output on Sheet2; I can see the very first entry and 27 populated rows. This is a correct reflection of the first record's data. It appears to be starting on column 2 but doesn't manage to complete the transaction.

At this point, it wouldn't make sense without you seeing a real sample. So I've neutralized our data and attached a tiny sampling to see.

Again; thank you very much for your assistance.