D
Deleted member 175603
Guest
I have the following two data(s) to combined into one table in Excel.
Data (1)
--------
Item Date (Quantity week 1)
---- ----- -----------------
A 1-Jan 100
*********************************************
Data (2)
--------
Item Date (Quantity week 2)
---- ----- -----------------
A 8-Jan 120
*********************************************
Overall Database (Actual format should look like)
--------------------------------------------
Item Date (Quantity week 1) (Quantity week 2)
--------------------------------------------------------------------
A 1-Jan 100
A 8-Jan 120
How to do the above two set of data to merge into one database whereby the input data will insert into the column (with defined header) accoding to the data capture?
Is there any script can be created using macro to run this data?
Data (1)
--------
Item Date (Quantity week 1)
---- ----- -----------------
A 1-Jan 100
*********************************************
Data (2)
--------
Item Date (Quantity week 2)
---- ----- -----------------
A 8-Jan 120
*********************************************
Overall Database (Actual format should look like)
--------------------------------------------
Item Date (Quantity week 1) (Quantity week 2)
--------------------------------------------------------------------
A 1-Jan 100
A 8-Jan 120
How to do the above two set of data to merge into one database whereby the input data will insert into the column (with defined header) accoding to the data capture?
Is there any script can be created using macro to run this data?
