I have a large Excel spreadsheet which is an export of a report from an Accounting software with over 10,000 customer records. I need to get this spreadsheet converted so every record has it's matching customer ID in each customer record/row. Unfortunately this report is formatted where it list the customer ID as a header and above an inconsistent number of records. Sometimes there is 1 record, other times there could be 30. To give you an example of the format, the first customer shows up in row 4 and in cell A4 it list the customer title "Customer:" and then list the Customer ID in cell D4 "123456". Then the first customer record is always listed 3 rows down where it always has the title "Record:" in this case the title in cell A7 and the first data showing in D7 with several more columns of data in that row 7 where I would like to add the Customer ID from cell D4 in each row that has the title "Record:" which for 1st customer only has 2 records, so rows 7 and 8. The next customer starts again in row 9 and has only one record in row 12. So the 3rd customer then shows in row 13 and it happens to have 17. So the next customer starts again in row 31, and first record in row 34. The pattern repeats. I'm at a lost here on what I could do outside of alot of manual work. Any ideas?
Bookmarks