Search results

Hi Jal, No, I have no VB or VBA knowledge.

Sorry, but I didn't accurately describe the format MSAccessRookie, I appreciate your reply. I'm at fault for not describing the format well. Col A, Row 11 Employee Name: John Doe Col A, Row 12 Address2: 7021 ANY SCHOOL RD Col A, Row 13 Gender: Female Col E Row 11 Employee SSN: 123-45-6789...

I received a spreadsheet that I need to change the format to columnar. It is currently spread across three lines for each entry. eg. Name JOhn Doe SSN 123-45-6789 EE Id 123 DOB 01/01/1990 ADDR 23 Any St Anytown, UT 68929 DEPT...