• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Move horizontal to vertical table

stormania

stormania

Member
Hi ..excell mania

Kindly help me as to change format table as in below

Product. 100. 110. 120
Pizza. 5. 8. 11
Cola. 7. 12. 4

Result should be
Product
100. Pizza. 5
100 cola. 7
110 pizza 8
110 cola 12
120 pizza 11
120 cola. 4

How formula in excell.? I am not understand vba..kindly use excell formula
Kind your help....thank you
 
Hi Somendra

Thank you for attention...after i looked the file..i am feell amazing with the result..but with my limitation experience...i have some question..
> cell light orange what the meaning ? should write those formula ?
> when i add table data on right, then i copy green cell to below..but why empty? because i have a huge data table like that.

Thank you in advance
 
Hi Somendra

How to write symbol on left or right at formula ? because when i am edit/F2 in formula and symbol not show, so formula will error/blank, and whats the meaning of those symbol (symbol/sign like curly braces)

Thank you
 
Hi, stormania!

Formulas that are displayed between curly braces { } are called array formulas, and instead of being placed just with Enter they must be inputted with Ctrl-Shift-Enter, and the curly braces are added automatically (for display purposes), as the formula should be typed without them.

Regards!
 
Ok..I am understand now...because this is first time for me to see formula like that
The result is amazing and my problem is solved
Thank you somendra and sirjb7
 
You must log in or register to reply here.
Back
Top