excel - return only values in a row -

-

i have list of unique ids , values on 1 sheet in excel in image below:

enter image description here

is there way return values in order appear (left right) on separate sheet/location? example, want return id '1002' values 35,32,44.. not blanks. going turn values sparkline.

i using excel 2010, if makes difference.

thanks! sam

try formula:

=substitute(trim(b2 & " " & c2 & " " & d2 & " " & e2 & " " & f2)," ",",")


edit: _______________________________________________________________________________

hope not late answer question.

lets assume data in sheet1 in image below:

enter image description here

now, in cell b2 of sheet2 enter following formula:

=iferror(index(sheet1!$b2:sheet1!$f2, small(if(isblank(sheet1!$b2:sheet1!$f2), "", column(sheet1!$b2:sheet1!$f2)-min(column(sheet1!$b2:sheet1!$f2))+1), column(a1))),"")

this array formula commit pressing ctrl+shift+enter

drag formula across till column f , down till row 4 or required. give following result.

enter image description here

i guess looking for.


Comments

Post a Comment

Popular posts from this blog

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de
Read more

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th
Read more

apache - Restler setup not working -

-
on webserver running apache/2.2.26 (unix) dav/2 php/5.4.24 mod_ssl/2.2.26 openssl/0.9.8y trying setup restler can't seem handle index.php properly. webapp setup httpd.conf looks so: alias "/dts2" "/usr/local/webapps/dts/root" <directory "/usr/local/webapps/dts/root"> allowoverride options -indexes followsymlinks </directory> so went 'root' directory , ran command install restler: composer create-project restler/application=dev-basic api --prefer-dist after that, in 'api' directory created .htaccess file looks so: directoryindex index.php <ifmodule mod_rewrite.c> rewriteengine on rewriterule ^$ public/index.php [qsa,l] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewriterule ^(.*)$ public/index.php [qsa,l] </ifmodule> <ifmodule mod_php5.c> php_flag display_errors on </ifmodule> and, when try access " https://..../dts2/api/home/ &
Read more