Incremental copying of data from one sheet to another

[Trompie]

I am having some difficulty in finding the correct formula to transfer data from one sheet (where the data is stored in a number of ranges on a row) and a database sheet where the data is stored vertically.

The data input sheet looks like this :
ROW#1/A /Value1/Value2/Value3/Value4 Space ROW#/B /Value1/Value2/Value3/Value4 Space ROW#/ C /Value1/Value2/Value3/Value4
ROW#2/A /Value1/Value2/Value3/Value4 Space ROW#/B /Value1/Value2/Value3/Value4 Space ROW#/ C /Value1/Value2/Value3/Value4
etc
These replicate vertically with the normal Excel incremental row increases, however the -

Database sheet needs to look like this
The data from the data input sheet needs to be transferred to this (Database) sheet which displays the information as follows :
ROW#1 /A /Value1/Value2/Value3/Value4
ROW#1 /B /Value1/Value2/Value3/Value4
ROW#1 /C /Value1/Value2/Value3/Value4
ROW#2 /A /Value1/Value2/Value3/Value4
ROW#2 /B /Value1/Value2/Value3/Value4
ROW#2 /C /Value1/Value2/Value3/Value4

I need to be able just copy and paste additional rows in this Database sheet (with all data A,B and C) without having to manually change the cell values.

Can anyone point me in the right direction??
Happy to post a sample spreadsheet if that will help.

[benishiryo]

hi Trompie, yes a sample spreadsheet will definitely help

[Trompie]

Hi benishiryo,

Attached sample spreadsheet of my problem.

Trompie

[benishiryo]

could have a better method out there, but this is all i can think of. Added 2 columns in your DataBase worksheet. The blue cells have to be manually keyed. The green cells & below & be copied down using formula.

let me know if it helps

[Trompie]

Hey benishiryo,
Thank you, I am sure there are other ways of addressing the issue but it's the old story, if it works, it works!!

Appreciate your help.
Trompie

[Trompie]

Hi benishiryo,
Not sure how to reopen this thread.
I have a small problem with the solution you proposed - the copy of data from the Input Data sheet to the DataBase sheet does not occur and I cannot find a solution.
Can you help?
I can send a sample file to illustrate the issue.
Regards,
Trompie

[benishiryo]

yeah upload the file & we can try to help

[Trompie]

Thanks, Appreciate your response.
Attached sample file that illustrates the issue under sheet DataBase.

[benishiryo]

i added in some absolute referencing & COLUMNS formula to make the copying to the right incremental. see if this works for u.
=)