Help in creating a Flat Data to a Database

[prkhan56]

Hello All,
I have posted this problem on the following thread

Help in creating a Flat Data to a Database

Dear All, I am enclosing herewith a sample file with the problem I have. I have a folder with lot of worksheets for each employee. Each employee fills up the detail as shown on the Input Sheet in the attached sample. I would like to have powe query to consolidate each employee's data from the...

chandoo.org

I had received a solution from Mr Alan but that is not according to my requirement.

So I am posting on this forum

I am enclosing herewith a sample file with the problem I have.
I have a folder with lot of worksheets for each employee.

Each employee fills up the detail as shown on the Input Sheet in the attached sample.

I would like to have power query to consolidate each employee's data from the folder and give the result as a database as shown on the output sheet.
[Unquote]

Thanks in advance
R Khan

 

[prkhan56]

Hello All,
Any help possible on my problem.

Thanks
RKhan

 

[prkhan56]

Hello All,

Any help on my problem please?

TIA
RKhan

 

[Pecoflyer]

Alan replied at Chandoo's

Based upon samples provided, I cannot provide any further assistance.

So there are probably missing pieces from your information

 

[prkhan56]

Ok thanks for the reply.

 

[AliGW]

You also need to explain the problem here. Nobody should have to go to another forum to find out what it is!!!

Which version of Excel are you using?

 

[AliGW]

If you have 365, remove ALL expected results from row 2 onwards on the output sheet, then make sure all columns are formatted as GENERAL.

Then, in A2 followed by ENTER:

=LET(sss,TRANSPOSE(Input!C4:C6),
ttn,HSTACK(Input!C10:C14,Input!B10:B14),
HSTACK(TAKE(DROP(REDUCE("",ttn,LAMBDA(x,y,VSTACK(x,sss))),1),ROWS(ttn)),ttn))

 

[prkhan56]

Hello AliGW,
Thanks for your reply. Works great.
I have O365.
Please see my original post on Chandoo.org

Dear All,
I am enclosing herewith a sample file with the problem I have.
I have a folder with lot of worksheets for each employee.

Each employee fills up the detail as shown on the Input Sheet in the attached sample.

I would like to have powe query to consolidate each employee's data from the folder and give the result as a database as shown on the output sheet.

Thanks in advance

As mentioned in my OP I need to perform it on a folder with several worksheets of the same nature. In future more files will be added to the folder as and when received.

How can I adapt your solutions to all the files?

Thanks once again for your time and help.

RKhan

 

[AliGW]

This requirement was NOT mentioned in your OP. All you said was this:

I had received a solution from Mr Alan but that is not according to my requirement.

So I am posting on this forum

and as I said in response:

You also need to explain the problem here. Nobody should have to go to another forum to find out what it is!!!

I did not look at the other forum. Don't expect peoplke to do so in future, please. I based my suggestion purely on the workbook attached.

I am not able to help you further with this - sorry.

 

[prkhan56]

This requirement was NOT mentioned in your OP. All you said was this:



and as I said in response:



I did not look at the other forum. Don't expect peoplke to do so in future, please. I based my suggestion purely on the workbook attached.

I am not able to help you further with this - sorry.

Hello AliGW,
Thanks for your support and help.
I was not aware that I should expalain the problem when I post it in another group. My impression was that I need to put the link of the post.

I will keep that in mind for future.

Thanks for the help once again.

RKhan

 

[AliGW]

The link is merely to show where else you have asked the question. However, you should state the question in full on each forum where you ask it and provide a workbook. Hope this is clear.

 

[Pecoflyer]

@prkhan56 Now you can see why cross-posting is not always a good idea...