Hello,
I am interested in extracting and listing values from different spreadsheets. The values should be grouped together according to the identifying information given in 3 columns (A-C), with the value given in column D.
As an example a sheet1 may contain the following in line 30:
A30=3099
B30=ABC 0.4
C30=KLM20
D30=45
Sheet2 in line 36:
A36=3099
B36=ABC 0.4
C36=KLM20
D36=40
Sheet 3 in line 25:
A25=3099
B25=ABC 0.4
C25=KLM20
D25=50
I am interested in extracting to a new sheet columns A-C (identifying information) and then listing the values (45, 40, 50...) in columns D, E, F....
Is there an easy way to do this?
Thank you,
Peter
Bookmarks