Tester checks template2.xlsxThis issue has stumped several local experts
I have a Excel file with 3000 records with staggered rows of information so a1 has name field b1 is blank but b2 has address field b3 has city b4 has state but a5 has zip code. b2 cells are wrapped so that if address is too long it will wrap to cell a2
It is easy enough to read as all records are contained in two rows.
It is a nightmare to create MSWORD labels as the fields are difficullt to define.
How could I modify the existing data base to make a single row contain all active cells (9 cells in row 1 and 8 or more cells in row 2 because of wraps)
I will be glad to share this confusing file for purpose of clarity in seeking solutions.
WSCOOK
Bookmarks