finnstone
asked on
need to create an array of values in excel
i have 100 rows, where i need to create a matrix from another 300+ rows.
so, just for row1, in tab A , I have the following in row 1
COLA COLB
row1 26.18599 -80.172721
in tab B, I have this
COLA COLB
row1 20.711955 -156.438498
row2 600 5888
in new tab , i need this
cola colB COLc colD
26.18599 -80.172721 20.711955 -156.438498
then in row 2 new tab 3 i need
26.18599 -80.172721 600 5888
and so on 300+ more rows of tab B against the first row of tab a
then 300 rows of tab against against second row of tab a
and so on
file attached
ZIP-COMARE-a-TO-b.xlsx
so, just for row1, in tab A , I have the following in row 1
COLA COLB
row1 26.18599 -80.172721
in tab B, I have this
COLA COLB
row1 20.711955 -156.438498
row2 600 5888
in new tab , i need this
cola colB COLc colD
26.18599 -80.172721 20.711955 -156.438498
then in row 2 new tab 3 i need
26.18599 -80.172721 600 5888
and so on 300+ more rows of tab B against the first row of tab a
then 300 rows of tab against against second row of tab a
and so on
file attached
ZIP-COMARE-a-TO-b.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER