Excel 2010 - Flattening of Data in 1 Row

Question
do you always have 4 rows for every Account ? or it may vary some 4 some 3 some 6 ... ?
then you want to endup with 1 row for each Account and all the columns as per your example then again will the columns vary or they are what you showed ?
gowflow

Some accounts may have more than 4 rows; in my example I used only 4 but I know some other Accounts have 6 or even more rows!

so then how do we flatten ... you will not have the same header !!! as when you have:

for 3 you will have
RA Date      RD Date      RA Date1      RD Date1      RA Date2      RD Date2

for 6 you will have
RA Date      RD Date      RA Date1      RD Date1      RA Date2      RD Date2      RA Date3      RD Date3      RA Date4      RD Date4      RA Date5      RD Date5

etc ....
so data will not be aligned in column ???

May I ask what are you trying to achieve ? maybe we can understand better what you want ?
gowflow

Question
Will there always be 4 rows for every Account ? or more or less ?
Presume you will have Accounts like this
BA1234
BA1234
BA1234
BA1234
BA1235
BA1235
BA1236
BA1236
BA1236
BA1236
etc...
and you want to end up with
BA1234
BA1235
BA1236
and all its related info in the columns right ?
gowflow

What about the complaint and the names, do they have to be the same or is it only the account?

Did you had a chance to check out my comment ?
gowflow

rustypoot,
Any news ?
gowflow

Sorry for the Delay! I was out of town! Thank you for the response though.

The end users want to see the data flattened in 1 Row. Only difference if for RADate and RDDate. I enquired more and they are ok with 6 dates as below in 1 Row along with other columns.

RA Date      RD Date      RA Date1      RD Date1      RA Date2      RD Date2      RA Date3      RD Date3      RA Date4      RD Date4      RA Date5      RD Date5

Can this be done now that there are fixed # of columsn requested? Thanks

yes it can beside the dates you have the other items they come after the dates ??? give me the whole line.
gowlfow

Attached please find the sample file. Thank you.
Test.xls

Fine let me recap if we have 3 it would go on the first 3 then the rest in the appropriate columns if 4 the first 4 etc... and this size would be fix right ?

Second question you want to flatten on a new sheet ? would be easier to read ?

Third can you post more data so the test would be better ?

gowflow

Sure I will post the updated file by tomorrow. Thanks

Thank you I will test it out and definitely give you the feedback Thanks

ok fine
gowflow

Thank you. It will work out for me. Thanks

Great glad I could help
gowflow