Transpose table in different sheet in excel -


i have 3 sheet in ms. excel. example sheet sheet b, , sheet c. in sheet have table can input 1 or o. in sheet b input conditional formatting formula ='sheet a'!i548=1, if in sheet cell i548 have value 1 cell input formula have green color, else if input of cell i548 o cell in sheet b fill grey color using formula ='sheet a'!i548=o. in sheet c want transpose table in sheet b, table did not transpose, , cell green fill , grey fill did not appear. how solve problem?

sheet b enter image description here

sheet c enter image description here

as far can see it, table in sheet b ranges column column h. if case, use =transpose() function in excel. note range select inside brackets array. example, transpose row "r" sheet b sheet c, following:

  1. since there 8 columns in table in sheet b, select 8 rows cell in sheet c (for example, select range "b27:b34")
  2. press "=" sign , type (without quotes): "transpose("
  3. once opened bracket, see prompt, saying choose array. array in case "r" row in table in sheet b, i.e. range "a1:h1". select range.
  4. now, press ctrl+shift+enter
  5. you see info in first row of table in sheet b transposed in sheet c. self check: have @ formula in 1 cell; if has these brackets { }, should fine in transposing data.
  6. now, copy formula right many columns in sheet c have rows in sheet b.
  7. with formatting, suggest re-apply same formatting style new table in sheet c.

Comments

Post a Comment

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

Image
recently have uploaded wordpress site onto server. have uploaded wordpress site in sub-folder under root folder ../root(domain root folder)/wordpress (where host wordpress folder). now problem content data in page or post in dashboard of wordpress admin panel not showing - see image. but data showing in front view - see image. if not browser cache issue , not issue happened tinymce editor during upgrade; try add config file: define('concatenate_scripts', false);
Read more

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

i trying ip address of vm , trying use establish ssh vm. following script: --- - hosts: localhost become: yes connection: local gather_facts: false serial: 1 vars_files: - createvmvars.yml tasks: - name: gathering vm info. vsphere_guest: vcenter_hostname: "{{vcenter_hostname}}" username: "{{vcenter_username}}" password: "{{vcenter_password}}" guest: "{{guest_name}}" vmware_guest_facts: yes register: var - debug: msg="{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" - name: establishing ssh connection. script: /home/shasha/devops/scripts/ssh_configure.sh "{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" following content of ssh_configure.sh : #!/bin/sh ssh-keygen -t rsa ssh-copy-id $1 but when running playbook, getting following error while executing third task: error! 'var' undefined but debug module(second task) printin
Read more

javascript - Get parameter of GET request -

i make request: createxhrrequest( "get", fileurl, function( err, response ) { if( err ) { alert( "error get!" ); } alert(response); }); and full response: { "status" : "ok", "message" : "jvberi0xljqkjdduxdgkmy how can jvberi0xlj ? i try response.message , response["message"]. nothing works. just simple access this: var json = json.parse(response); json.message
Read more