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

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

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -

Image
i have not tryed since can't understand space between tooltip , element made/added bootstrap, tooltip near element triggers tooltip event. i make tooltip opening little bit away element, add more margin tooltip , eleemnt mean. i understand how in css if possible , if possible make both right,left,top,bottom tooltips hope question clear. this how tooltips looks on app: and , how should looks after this default css tooltip on top : .tooltip.top { padding: 5px 0; margin-top: -3px; } you can override in own css : .tooltip.top { margin-top: -10px; } note code work work tooltip on top, you'll nedd adapt css 3 other orientations : .tooltip.top { margin-top: -10px; } .tooltip.right { margin-left: 10px; } .tooltip.bottom { margin-top: 10px; } .tooltip.left { margin-left: -10px; }
Read more