Hello all,
I have received an Excel file that is structured as follows.
(there are more columns, this is to give you an idea). There are around a 1,000 customers and each customer has 4 lines. Some cells have been merged.
I need to convert this to a single line database: all data for each customer needs to be on a single line.
How to achieve this (easily)?
regards,
rhobert
I have received an Excel file that is structured as follows.
customer 1 ID | customer 1 name | customer 1 email | customer 1 website |
customer 1 address | customer 1 post code | ||
customer 2 ID | customer 2 name | customer 2 email | customer 2 website |
customer 2 address | customer 2 post code |
(there are more columns, this is to give you an idea). There are around a 1,000 customers and each customer has 4 lines. Some cells have been merged.
I need to convert this to a single line database: all data for each customer needs to be on a single line.
How to achieve this (easily)?
regards,
rhobert