Unscrambling a data base help needed

[jtwilber57]

So I am trying to unscrew a cvs file that come out of an ACT program written to manage subscriptions. The Act file had the ability for a customer to have up to three subscription in his "record" so basic fiields had a Start date 1 start date 2 start date 3, end date 1, end date 2 etc etc.

So the attached mockup sample shows the the output to a cvs file.

the attachment also shows what I am trying to do. Basicly get it translated into a simpler start, end, cost, code data base.

I don't even know where to start ? Macros, VB code, etc.

Help appreciated.

[JBeaucaire]

Assuming the data is in the columns as you presented, like so:

Please Login or Register  to view this content.

[AliGW]

NON MACRO/CODE SOLUTION

In A21:

=IF(COUNT(A3)=1,A3,IF(COUNT(C3)=1,C3,IF(COUNT(E3)=1,E3,"")))

In B21:

=IF(COUNT(B3)=1,B3,IF(COUNT(D3)=1,D3,IF(COUNT(F3)=1,F3,"")))

In C21:

=H3&I3&J3

In D21:

=K3&L3&M3

Copy the formulae down.

[mrice]

Please see the attachment. Look at Sheet 2 and press button to populate sheet3.

Code is in Module1.

[jtwilber57]

Thank you all so much for the replies. I will be going through the solutions this afternoon. I don't have much VB \ developer experience but its never to late to learn some new things.

[JBeaucaire]

How did things go? Did one of these or all of these work for you?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.