Forum Discussion
Excel Online Conditional Formatting - Unable to Edit Existing Rules
Hi, I have a file that was originally created in Excel Desktop. We are wishing to move the file to only online to prevent change/version errors. The conditional formats that were created on desk...
Dear Sir,
Please see the below table.
NAME COCACOLA HOSLICS ICE CREAM BISCUITS
KADAPA 100 25 10 68
HYDERABAD 41 53 57 94
KARIMNAGAR 42 69 38 28
VIJAYWADA 19 91 73 37
I need to excel formula is below as per below table please confirm the same.
NAME COCACOLA HOSLICS ICE CREAM BISCUITS
KADAPA 100
KADAPA 25
KADAPA 10
KADAPA 68
Please see the below table.
NAME COCACOLA HOSLICS ICE CREAM BISCUITS
KADAPA 100 25 10 68
HYDERABAD 41 53 57 94
KARIMNAGAR 42 69 38 28
VIJAYWADA 19 91 73 37
I need to excel formula is below as per below table please confirm the same.
NAME COCACOLA HOSLICS ICE CREAM BISCUITS
KADAPA 100
KADAPA 25
KADAPA 10
KADAPA 68
1) that is separated question, much better to start new thread in such case.
2) Much better if you provide sample file instead of numbers within post
3) In general that's job for Power Query - query the table, select name and unpivot other columns
- Dear Sir,
Thanks for your replying.
Regards
Mallesh