ExcelBanter - ALIGNING TWO ARRAYS OF DATA VALUE

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ALIGNING TWO ARRAYS OF DATA VALUE (https://www.excelbanter.com/excel-worksheet-functions/192018-aligning-two-arrays-data-value.html)

sunan

ALIGNING TWO ARRAYS OF DATA VALUE

This si about comparing two sets of separate data into one aligned worksheet
as folows:
XXX 300
YYY 250
ZZZ 175
XXX 312
YYY 267
ZZZ 177
to be aligned:

XXX 300 312
YYY 250 267
ZZZ 175 177

Can we do it the simple way?
thanks,
sunan

--
sunan

Herbert Seidenberg

ALIGNING TWO ARRAYS OF DATA VALUE

Try Pivot Table.
No formulas needed.
http://www.savefile.com/files/1621696

All times are GMT +1. The time now is 01:46 AM.