add multiple field values in to one Columns

[#1]

Hi All,

I need all your suggestion & help for arriving at a Logic

Can you please see the atached file.

First sheet is the Master Table , 2nd Sheet is the Fact Table & 3rd Sheet is the Report Outpurt Required by me.

Hope to hear from you all soon .. 🙂

Srini

[#2]

done 🙂

[#3]

Hello Srini,

would you mark your Thread as "answered", so everybody knows that there is no (more) answer necessary.

Rgards, Roland

[#4]

Hello Ronald,

Thanks for your input 🙂

Can you please guide me how do i make this thrad being answered correctly (Trying to seacrh where exactly i have to click as "Aswered").

Well meanwhile i am having one more doubt in this thread & wish to continue the thread

If in case i have the same Datasource (as orginal) but i am changing some values in the 2ndsheet(Sheet Name = Trans).

I would like to see the report as mentioned in sheet 3( Sheet Name = Report).

Need help from you all

Thanks in Advance:-)

Srini

[#5 · Accepted solution]

Hello Srini again,

you as the thread owner can mark every post as an anwer to your question. Even your "answer-post" above can be marked as an answer. Then the Thread is flagged green and can be seen as solved.

To answer your second question: Take a look at my sample app. I read the values of cust and suppl twice into new columns. I guess this is the right direction.

RR

[#6]

thanks Ronald. 🙂

[Anonymous]

Hello Srini,

is there a chance, that you could post you solution, I am having the exact same problem at the time.

Kind reagrds,

Karsten