I have a spreadsheet containing just over 4000 rows (including a header row).
The number of rows will increase each month as more data is added.
The data is extracted from another system and is not particularly
user-friendly, as explained below. Basically, I want to combine data from
multiple rows.

At present, there are varying number of rows associated with each customer -
one customer may have 10 rows, one may have 12, one may have 3, etc..
Columns B, C and D will always contain data (Customer ID, Customer Name and
Status).
Only one of the rows for each customer (never the same between customers,
i.e. never always the 3rd row, or never always the 5th row, etc) will show a
value in column A. Policy values, relating to specific months, will be shown
in columns E to Z on an undetermined number of rows (undetermined, as one
customer might show policy values for 3 months, i.e. 3 separate rows, or
values for just 1 month, i.e. 1 row). Another row might show data
(numerical, dates and text) in varying columns AA thru to CB. Any rows
remaining for each customer will show values in columns B, C and D only.
For each row containing data in columns E to Z, I need to copy through the
value in column A and any values in columns AA to CB.

Agency ID / Co. ID / Name / Status / E - Z / AA - CB
(blank) / 1234 / Company A / Main / (blank) / (blank)
9999 / 1234 / Company A / Main / (blank) / (blank)
(blank) / 1234 / Company A / Main / Currency Data / (blank)
(blank) / 1234 / Company A / Main / (blank) / Numerical and text data
(blank) / 1234 / Company A / Main / (blank) / (blank)
(blank) / 2468 / Company A / Main / (blank) / (blank)
(blank) / 2468 / Company B / Main / Currency Data for Month 1 / (blank)
(blank) / 2468 / Company B / Main / Currency Data for Month 2 / (blank)
8888 / 2468 / Company B / Main / (blank) / (blank)
(blank) / 2468 / Company A / Main / (blank) / (blank)
(blank) / 2468 / Company B / Main / (blank) / Numerical and text data


The result should be:

Agency ID / Co. ID / Name / Status / E - Z / AA - CB
9999 / 1234 / Company A / Main / Currency Data / Numerical and text data
8888 / 2468 / Company B / Main / Currency Data for Month 1 / Numerical and
text data
8888 / 2468 / Company B / Main / Currency Data for Month 2 / Numerical and
text data

(the numerical and text data for multiple rows for one customer will be the
same)

I hope someone can help - I just want advice re how to do this in the most
easiest way (if there is one)? Any ideas?