Merge rows by ID in excel -


i've got set of columns in excel:

id                                      sizeandcolourandsku_value 2ff0d3d7-8c18-4386-83be-1b2485fb4ea9    select size 2ff0d3d7-8c18-4386-83be-1b2485fb4ea9    small - available (only 1 left) 2ff0d3d7-8c18-4386-83be-1b2485fb4ea9    small - available (only 2 left) 2ff0d3d7-8c18-4386-83be-1b2485fb4ea9    medium - available (only 2 left) 2ff0d3d7-8c18-4386-83be-1b2485fb4ea9    large - available (only 1 left) 4697ce05-2e50-4e67-85d5-ad733e15ae95    select size 4697ce05-2e50-4e67-85d5-ad733e15ae95    6 - available (only 2 left) 4697ce05-2e50-4e67-85d5-ad733e15ae95    8 - available (only 4 left) 4697ce05-2e50-4e67-85d5-ad733e15ae95    10 - available (only 6 left) 4697ce05-2e50-4e67-85d5-ad733e15ae95    12 - available (only 6 left) 4697ce05-2e50-4e67-85d5-ad733e15ae95    14 - available (only 4 left) 4697ce05-2e50-4e67-85d5-ad733e15ae95    16 - available (only 2 left) 4697ce05-2e50-4e67-85d5-ad733e15ae95    select size

i need combine merge them id results become this:

2ff0d3d7-8c18-4386-83be-1b2485fb4ea9   small  small  medium  large 4697ce05-2e50-4e67-85d5-ad733e15ae95   6      8      10     12      14

i read here quickest , easiest way pivot table in excel

http://www.excelbanter.com/showthread.php?t=235727

however i'm using excel 2010 , method they've provided doesn't work, able me out this?

thanks

if pivot on data range , apply id field 'row labels' , sizeandcolourandsku_value field both 'column labels' , 'values' similar, except give count of occurrences rather values themselves.


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more